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
--
zulhaida

take a look at advanced filter.

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



"zue" escreveu:

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
--
zulhaida

"URGENT" means very little around here.

All postings are dealt with equally as they appear.

See Ron de Bruin's CopyPasteMerge section for retrieving data from
multi-workbooks and multi-worksheets.

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


Gord Dibben MS Excel MVP


On Thu, 19 Jun 2008 04:02:02 -0700, zue wrote:

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