Previous Topic Next Topic

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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response