Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two worksheets
a master sheet and a week 4 sheet. The data and columns are set up the same titles however the datawithin the sheets isnt in the same order. I want to be able to update the master sheet with any differences on the week 4 sheet. I have built two helper columns one that has a Vlookup formula to bring over the value from the master sheet onto the week 4 sheet and then i have a second column that has an if statement checking to see if the values are the sameto insert a match and if they are different then insert the word update. Now that i can filter the "updates" i wanted an easy way to make the updates to the master. I also have 6 other columns that i need to do the same thing for. Is there an easier way to accomplish these updates? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there an easier way? | Setting up and Configuration of Excel | |||
Is there an easier way... | Excel Discussion (Misc queries) | |||
Easier said than done | Excel Programming | |||
Easier Way to do it? | Excel Programming | |||
Easier way? | Excel Programming |