AnsweredAssumed Answered

Monthly sales figures

Question asked by SteveGoodall_1 on Aug 11, 2015
Latest reply on Aug 11, 2015 by philmodjunk


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,