LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 106
Default is there an easier way to update?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there an easier way? Bigpond Setting up and Configuration of Excel 2 September 17th 08 03:17 PM
Is there an easier way... George[_4_] Excel Discussion (Misc queries) 1 August 28th 08 12:44 AM
Easier said than done Gordon[_2_] Excel Programming 1 July 6th 06 12:03 PM
Easier Way to do it? Kurt Barr Excel Programming 3 January 13th 06 06:20 PM
Easier way? davegb Excel Programming 4 December 9th 05 06:47 PM


All times are GMT +1. The time now is 12:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"