Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Match function to replace
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error for a replace. It replace ALL instead of selected column | Excel Programming | |||
Index? Match? Function to sort and return value fr diff column in | Excel Worksheet Functions | |||
How to replace column letter in refferences with a function using the old column letter? | Links and Linking in Excel | |||
How to replace column letter in refferences with a function using the old column letter? | Excel Worksheet Functions | |||
Is there any way to use the MATCH function with more than 1 column | Excel Discussion (Misc queries) |