Forum Discussion
Ajay_soni985
May 03, 2024Copper Contributor
apply macro
Sheet 1 contains data files, while Sheet 2 has a macro applied to automatically convert data into a specific format. I need the data from Sheet 1 to be automatically transformed according to the format specified in Sheet 2 using the macro. Please download this file and apply macro and send me on my mail id (ajay.soni529ATgmail.com) ( https://docs.google.com/spreadsheets/d/1mkHZlLH1cjKRNVoJT0VeW-f4wddtVmIzCQw1prc14vc/edit#gid=628912693 .
Please apply the macro to the file, transforming the data in Sheet 1 to match the format specified in Sheet 2, and then send me the updated file. Thank you!
You
Your workbook is a .xlsx workbook, so it does not contain any VBA code (macros).
- Ajay_soni985Copper ContributorI need assistance converting the data in Sheet 1 to match the format of Sheet 2. Could someone help me apply a macro to achieve this? I lack expertise in macros, so I'm seeking guidance to transform the data in Sheet 1 to resemble the format specified in Sheet 2.
I don't understand how Sheet 2 relates to Sheet 1.