Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to paste/update info to correct row.
NEW TO VBA and use recorder for most of my activities.
I need to update rental unit information when changed on a userform/display sheet. I have all the information arranged on a data table so that each row represents a unit, and the columns contain different info for that unit (ie. client info, unit price, etc.). Using the userform/display that is populated with the current data, I need the user to be able to alter it and update the unit on the data table. I know how to use a index with nested vlookups if needed to find the exact cell, but I want a macro to find the corresponding row for the unit#, and paste over the row with the "updated" data. I already have the data arranged in an identically sequenced row with the unit# listed first, so I can have the user paste the whole thing. Regards, Lonpuz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto correct/update values in two related columns | New Users to Excel | |||
my vlook up is not pulling the correct info from column 2 | Excel Worksheet Functions | |||
Using a date range in a formula to pull info to the correct column | Excel Worksheet Functions | |||
Paste Functions and Update info | Excel Worksheet Functions | |||
how do you paste just specific info and not the hidden info? | Excel Discussion (Misc queries) |