Using sheets in excel

Closed
klausnick
Posts
1
Registration date
Thursday June 12, 2014
Status
Member
Last seen
June 12, 2014
- Jun 12, 2014 at 10:23 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Jun 12, 2014 at 11:15 AM
Hi,

I am using excel 2007 and have a product database in sheet 1 with multiple columns.

I want to take selected columns from this product database and have them appear on sheet 2 so that I can submit them to google.

Whenever I update sheet 1 I want the selected columns to update in sheet 2. I hope that makes sense!

I am absolute novice so not sure if this requires macros

THANK YOU

1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Jun 12, 2014 at 11:15 AM
Hi Klausnick,

Let's say you want to keep column B from sheet 1 and place them in column A of sheet 2.
Go to sheet 2 cell A1. Type = and go to sheet 1 cell B1 and hit enter. Now drag sheet 2 cell A1 down as far as needed and all the values from sheet 1 column B are now also in sheet 2 column A. Repeat for other columns.

Best regards,
Trowa
0