Column Match function to replace

S

SteveT

Hello,

I have 2 sheets
1st SH - User uses List validation to choose from column headers in 2nd sheet
after choice made, vlookup function brings info under column header to sheet
1.

I want user to be able to alter the info came over with event macro (vlookup
/ copy / pastes ) and update the column in SH2.

cell Z1 contains match formula to match up header to proper column in SH 2.
How can i build code to use the matched column to properly overide the
existing data with altered.

My problem isn't with the middle part (copy / pasting) but just how to
define that matched value as the proper column to override.

Hope makes sense... your help most appreciated.

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find and Replace 6
Create if partial match then copy and paste data from one cell to another 1
OFFSET LOOKUP function in VBA? 9
Impleted the following code 0
Skip copying empty column where remaining rows are filled 2
hidden rows, column copy-paste 0
Copy range if match 2
Somewhat complex code to copy data from one sheet to another 9

Top