apply macro

Copper Contributor

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=6289126...

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
 

 

5 Replies

@Ajay_soni985 

Your workbook is a .xlsx workbook, so it does not contain any VBA code (macros).

I 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.



@Ajay_soni985 

I don't understand how Sheet 2 relates to Sheet 1.

@Hans Vogelaar yes sheet not related please do changes accordingly

@Allen_ajay 

That is beyond the scope of what I can help with, sorry.