Update Cell Value on Multiple Sheets that Match Another Cell

Microsoft Excel 2010 - complete product...
July 23, 2014 at 07:52:06
Specs: Windows 7 Service Pack 1
I have a master sheet that we are using to update pricing. What I would like to do is go through all the worksheets in the workbook and find the matching descriptions and update a "Purchasing Notes" cell value with the current price and date that I have combined in another cell. Is this possible?

See More: Update Cell Value on Multiple Sheets that Match Another Cell

Report •


#1
July 23, 2014 at 12:49:37
What do you mean by "find the matching descriptions"? Are they in all different locations on different sheets? Can you not simply use this formula?

=SHEET2!A1

I think we are going to need some more detail related to your workbook before we can offer a solution.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

#2
July 23, 2014 at 13:04:02
Yes the description will show up multiple times on different spreadsheets throughout the workbook. I can do a VLOOKUP on each of the sheets back to the Master Sheet but I was wondering if there is possible a better way?

Report •

#3
July 23, 2014 at 15:06:01
Since you still haven't given us much detail, all I can do is ask...

If VLOOKUP works, why are you looking for another method?

Until we know more about your worksheets and exactly what you are trying to do, there's not much we can offer.

Keep in mind that we can't see your workbook from where we're sitting nor can we read minds.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question