need an aswer- URGENT!

[zue]

I have a data by heading in a file as a master data file. I do have form 7
file with 10 worksheet. each worksheet represent single form.
In master data file I have many data in row so I need to extract each data
in every row to paste in correct worksheet.
Its possible to do it in excel? I hope it can, rather than I use a copy
paste manually each row(cell by cell) to paste in a single worksheet (in a
specific colom) as I have about 4000 row to copy and paste and all data neet
to print out each row belong to 1 worksheet.

Please help me.....I hope I could save a time by doing some fomula or set
funtion rather than copy paste manually to each workseet.

thanks

 

[Marcelo]

take a look at advanced filter.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"zue" escreveu:

 

[Gord Dibben]

"URGENT" means very little around here.

All postings are dealt with equally as they appear.

See Ron de Bruin's Copy>Paste>Merge section for retrieving data from
multi-workbooks and multi-worksheets.

http://www.rondebruin.nl/tips.htm


Gord Dibben MS Excel MVP