jackhack88 Posted July 1, 2022 Report Share Posted July 1, 2022 Hi experts I have set of data in two sheet, i want copy data from 2 sheet , paste into corresponding value sheet name, through multiple command buttons for e.g Condition 1 : Rawsheet1 Column B have data south and Rawsheet2 Column B have data south, from both sheet all data south copy to south sheet, 1st range(A30:G30) 2ND RANGE(I30:O30) Condition 2 : In sheet south In column C have states data when i click state wise command button corresponded states data will be in both range please find the attachment CMD_Remote.xls Quote Link to comment Share on other sites More sharing options...
acantor Posted July 1, 2022 Report Share Posted July 1, 2022 You might receive better advice by posting your question on a VBA forum rather than a Macro Express forum. There may be a way to do what you want to accomplish with Macro Express, but the Macro Express script won't be as pretty as a VBA script. Quote Link to comment Share on other sites More sharing options...
Cory Posted July 1, 2022 Report Share Posted July 1, 2022 One might be able to do this in MEP. If you're interested in that alternative to VBA, you might find some help here. I don't follow exactly what the steps are, but sometimes it's good to export the data to a CSV and then run ASCII File Process. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.