jackhack88 Posted July 1 Report Share Posted July 1 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 Report Share Posted July 1 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 Report Share Posted July 1 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.