Previous Topic Next Topic

Using sheets in excel

[Closed]
Report
Posts
1
Registration date
Thursday June 12, 2014
Status
Member
Last seen
June 12, 2014
 -
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
 -
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

Answer 1 / 1
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
 486
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
Ask a question