Monthly sales figures
Hello Again – I hope I have an interesting problem that you can help me solve.
As usual the reason for the problem is my ignorance & twenty plus years of using another program.
Anyway – here is what I want to do – but can’t with my current skill level…
I review end of month sales figures from six depots across the UK – each with around 1,000 to 8,000 account holders.
At month end I am supplied with an excel spread sheet showing all account ref codes & the end of month sales figures for each account at each depot.
So – for example if I find all the accounts for depot A & then sort them A to Z in filemaker (this I can do this bit) – I can then open the depot A spreadsheet – again sort accounts A to Z – then highlight the sales figures, copy them & then paste them into the next column to the acc ref in filemaker.
The problem is – it drops all the figures into the first cell of the column & not each value into each cell in the column.
Can anyone help on this one???
Thanks as always,