Previous Topic Next Topic

Using sheets in excel

Closed
klausnick Posts 1 Registration date Thursday 12 June 2014 Status Member Last seen 12 June 2014 - 12 Jun 2014 à 10:23
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 12 Jun 2014 à 11:15
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

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
12 Jun 2014 à 11:15
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

Similar discussions

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

6 responses
How to export datatable to excel using c# in ASP.NET?
Vikram_27 -
ac3mark -

3 responses