Forum Discussion
Brittany0724
Oct 30, 2020Copper Contributor
Moving Rows Based on Information in a Cell
I am trying to create a Macro that when ran it will move certain rows depending on the value in the cells in a specific column. I have a spreadsheet that I need to split into two sheets depending upo...
NikolinoDE
Nov 09, 2020Platinum Contributor
Hello, here is an additional approach with VBA that I found on the Internet.
You can customize it according to your wish.
Hope this will help you too.
Thanks for your time and patience
Cheers
Nikolino
I know I don't know anything (Socrates)
mtarler
Nov 09, 2020Silver Contributor
NikolinoDE Hello my friend. I was curious and looked at the macro file you just sent and I don't read German but from what I can work out based on the algorithm of what the macro is doing I believe it is doing the opposite of what the original poster wanted. It appears to take a workbook with many sheets in it, in this case A-01, B-02, C-03.... each with date and then MERGING all those individual sheets of data into 1 master table.