I am struggling to copy and paste data from large sheet and need help if anyone can help me to write VBA.
I want to split data from main sheet named “ALL DATA” to multiple sheets.
Headers are from A1 to M1 in Row A1
Name of sheets are entered in Column (“A2:A”)
I want to copy data from column (A2: D2) & rows can be many of “ALL DATA” sheet
I want to create sheets automatically by names given in Column (“A2:A”) if not already created and copy data in each sheet when I run Macro.
I want to split data from main sheet named “ALL DATA” to multiple sheets.
Headers are from A1 to M1 in Row A1
Name of sheets are entered in Column (“A2:A”)
I want to copy data from column (A2: D2) & rows can be many of “ALL DATA” sheet
I want to create sheets automatically by names given in Column (“A2:A”) if not already created and copy data in each sheet when I run Macro.