Copy Paste Latest Value Macro

Eaglboy1

New Member
Joined
Apr 19, 2016
Messages
20
Hey there everyone. There is probably already a question about this somewhere, but I can't seem to find it, so I'm creating my own.

What I'm trying to do is this: I have a macro that uses drop down menus to populate certain fields. I'm working on creating a second macro that will run immediatly after the first that will ask a simple yes/no question. If the answer is yes, I want my new macro to only copy the latest entered information and paste it to another sheet on the first available line. All of this information will be in different locations, so I can't use standardized ranges. Is there any way to create a macro that will accomplish this?

I'd appreciate any help I can get on this. Thanks!
 
I just wanted to come out here and say thanks one last time. With that new code in place, I finally got it all set up and it works like a DREAM! Your help has been greatly appreciated Roderick_E.
 
Last edited:
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top