Jump to content
Macro Express Forums

Need VBA Code to copy data from 2 rawdata sheets paste into corresponding sheet depends upon command button


Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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. 

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...