Software

Ask something
Discussion Locked

Comparing Cells

0 helpful
9 replies

by michael_d'hanis

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Using Excel 2000, I have a spreadsheet that I utilize on a daily basis to keep track of opening propeties. I also receive a weekly spread sheet that is "the official" opening dates. Is there a formula that I can easily update my daily spreadsheet with date changes in "the official" spreadheet?

9 replies

by dklippert

The short answer is yes.
The longer answer depends on data definitions.
If some ID can individually identify your properties, you can set up a lookup table using the formula:
VLOOKUP(Lookupvalue, tablerange, columnnumber, closestmatch).
You may want to combine this with an IF statement that compares today?s date with the opening date and.
=IF(VLOOKUP(PropertyID, OpeningDateTable, 2, False) >Today(), ?Closed?, VLOOKUP(PropertyID, OpeningDateTable, 2, False) >Today())

by asmaklad

I'm not sure I understand the Question, but what you can do is t compare two rows/coloumns of celss:
- Sort the two sets
- press F5 (goto)
- press [special]
- then chose row or Coloumn diffrences.

a set of cells will be "Selected", I would recomend to Bold them or change their color

by michael_d'hanis

Let me go a little bit further into issue. Along with identifing properties (INNCODE) there are other colums/fiels between both spreadsheets that I do not need updating either way. I do believe Doug is on the right track.

by sankulpune

Hello Michael,

1) Paste-link all the related cells in the weekly worksheet into the cells in the daily worksheet that may need to be updated. You need to do this only once.

eg: In a cell in daily worksheet a cell may contain formula like this:

='C:\My Documents\[WeeklySheet.xls]Sheet1'!$F$9

When the latest weekly sheet arrives, rename the old weekly sheet to some other name; and rename the new weekly sheet to WeeklySheet and update the links. Repeat the procedure every time a new weekly sheet arrives.

You need to maintain the old weekly sheet till the new sheet arrives and avoid updating links until new weekly sheet arrives.

I hope, this works for you.

I would be glad to provide any more help you may need in this regard.

With best compliments,

SanganakSakha,
Effective and Simple Solutions To Small Problems, No QuickFixes

This discussion is closed to new replies.