R
RickyDee
Good morning.
Maybe I may have to learn VBA or something here. Here
goes:
Both sheets have the same information in column A
Sheet 1 -- Information to fill in.
SHeet 2 -- prices etc.
Sheet 1, cell a1, tools
Sheet 2, (cell a1, tools), (cell b1, 2.95).
All information in Column A (both sheets) is always the
same, but relocate up or down the column depending on the
item in stock, but the item name is always there.
(sometimes spelled differently, but always there.)
Match up the names between sheet 1 and sheet 2 in column
A, and whatever column B has, place it in sheet 1, column
B right next to the matching item name.
Please advise. And thank you, guys and gals.
Have a fine, and safe, day,
RickyDee
Maybe I may have to learn VBA or something here. Here
goes:
Both sheets have the same information in column A
Sheet 1 -- Information to fill in.
SHeet 2 -- prices etc.
Sheet 1, cell a1, tools
Sheet 2, (cell a1, tools), (cell b1, 2.95).
All information in Column A (both sheets) is always the
same, but relocate up or down the column depending on the
item in stock, but the item name is always there.
(sometimes spelled differently, but always there.)
Match up the names between sheet 1 and sheet 2 in column
A, and whatever column B has, place it in sheet 1, column
B right next to the matching item name.
Please advise. And thank you, guys and gals.
Have a fine, and safe, day,
RickyDee