Copy and paste data to bottom empty row on new sheet

Hi,

I'm fine excel when it comes to formulas, but my knowledge of VBA barely scratches the surface. I'm hoping someone can help me figure out my problem.

I'd like cell L3 and M3 to copy and paste from a sheet titled "Local Regression" to column A and B in a sheet called "Historical increase". Is there a way to do this? In my mind I had imagined that I could do it by recording a macro and then insert a button so after an item was picked from a dropdown in L3 and a # typed in M3, that they could click the button and it sends it to the new sheet without writing over historical data.

If there is a VBA code for this, is there also a way to include it as a button? I've only pasted VBA into spreadsheets a couple of times before, so if you can dumb it down for a normal human I would appreciate it!

Maybe:

Please Login or Register  to view this content.

http://www.wikihow.com/Create-a-Cust...utton-in-Excel

Awesome, thanks!

Now the second piece to this question is the following:

How do I take that newly created list and use a vlookup formula to return the most recently added cell in column B for that corresponding line in column A? Hopefully this is an easy once since you made child's play out of my last question.

Thanks again!

you would have to use a 3rd sheet to track what cells were added.

What do you mean? I was under the impression that I could use vlookup or match to find the bottom-most corresponding value in Column A. You don't think there's a way to do that?

Originally Posted by Alex0929

Awesome, thanks!

Now the second piece to this question is the following:

How do I take that newly created list and use a vlookup formula to return the most recently added cell in column B for that corresponding line in column A? Hopefully this is an easy once since you made child's play out of my last question.

Thanks again!

Not sure which poster you are talking too. When there is more than one you should indicate. If you are referring too my suggestion A and B values should already be there.

Originally Posted by JOHN H. DAVIS

Not sure which poster you are talking too. When there is more than one you should indicate. If you are referring too my suggestion A and B values should already be there.

Sorry, I'm referring to your solution. So the way the sheet works is that I have about 50 choices in my original dropdown in L3, and then M3 is a variable #. So what I'm looking to do with the data that now computes to "historical increase" is look for each of my 50 options and give the # down the list in column B that is the furthest down.

Ex:
L3 M3
L1A2 5%
L1A2 6%
L1A2 5.5%

So now in my historical increase sheet I see both, but I want to return the latest added to the list. Hopefully that's a bit more clear.

Thanks

Can you attach a sample with some data? Perhaps a visual would help too better understand. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Originally Posted by JOHN H. DAVIS

Can you attach a sample with some data? Perhaps a visual would help too better understand. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Capture.jpgCapture1.PNG

My file is too large, but see the attached pictures.

I'm now wanting the most recently added corresponding % to feed back next to my pivot table in column L. The pivot stops at column K.

The entire purpose of this is since manual data is static and won't stay next to a pivot table, I want to get this data to feed back by way of forumla so the data will constantly update regardless of what I have selected in the pivot.

Hopefully that helps.

Looks like you already have a VLOOKUP formula in Column L. I can't tell from your snapshot, what value it's searching for? It would be better to attach a file. Even with a couple of lines of dummy data set up as your main file not the entire file. Just to see what's happening.

Does this one work? So now as I enter info into P3 and Q3 and click my button, the macro (not included in this file) send its to my column A and B. My ultimate goal is to then return the most recently added item on that new list back to the table from in column P. You can see I used multiple L*A2 %s in column B for the example. I don't necessarily want the highest, just the furthest down the list.

Maybe:

Please Login or Register  to view this content.

Originally Posted by JOHN H. DAVIS

Maybe:

Please Login or Register  to view this content.

That's almost there. What it's doing is returning the same % in all cells in the table rather than using the lookup to determine it. Any ideas?