VBA

[cdoggett]

How can I write formula or VBA to move whatever number is in a specific column to move that row of data to the corresponding sheet that is named the same as the number in the column. So if column H has 0078 move data in that row to sheet that is titled 0078? But I need it to move all data at once. Not me writing a code for each sheet and each number as I have over 4800 lines that need to be moved

 

[davesexcel]

You can do a forum search on moving data based on criteria.