How can I automate copying data from one into several spreadsheets

[Guest]

I have a spreadsheet listing sales figures for 50-odd different suppliers. I
need to copy sales figures for each supplier into separate spreadsheets which
are then emailed to them on a weekly basis; the spreadsheets must be named
after the supplier. Is there an easy way to do this (using a macro etc)?
Copying, pasting and saving the data is a rather time-consuming task at the
moment.
Thanks
Andy

 

[Guest]

One way using non-array formulas
which could deliver the required automation ..

Try this sample construct from my archives:
http://www.savefile.com/files/430142
AutoCopy Lines to Resp Sht Non Array.xls
(Full details inside, nicely rendered. Easy to adapt ..)

Data is continuously entered in a master ("parent") sheet, with lines neatly
auto-copied to each individual ("child") sheet based on the values within a
key col.

In the sample, the key col in the master sheet is the "States" col, which
may contain eg: NY, NV, CA, etc. All lines with "NY" in the key col will be
auto-copied to the sheet named: NY, and appear neatly bunched at the top.
Ditto for lines with "NV", "CA", etc.

Propagation of the "child" sheet is as simple as making a copy of the
initial one, then renaming it accordingly as the key col value. Eg we first
formulate one child sheet for "NY", dress it up nicely, then just make copies
of the "NY" sheet, and rename these as: NV, CA, etc

In your instance, the key col would be "Suppliers

 

[Don Guillett]

Doable with a for each loop for each supplier in a list.
http://www.rondebruin.nl/