Automatic Transfer Data by Row

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,


I need to automatically transfer data, from a set of three spreadsheets
- one row at a time
- if a specific column contains a specific code [letter "T"]
- going from one spreadsheet to another spreadsheet
- ultimately populating the Summary or Top10 spreadsheet

- all spreadsheets are contained within the same workbook.

I am not a member. I searched Google and found this website/forum

Thank you

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
"- one row at a time "
why one row at a time. why not all the relevant row in each sheet at one stoke and then loop to all the sheets

"ultimately populating the Summary or Top10 spreadsheet
"
are the above to copied to summary sheet??? what is meant top ten sheets. what is the definition of "top" is it the first sheet or the last sheet in the workbook.