Jump to content

Spreadsheet question: How do I get all the information from a column copied into a column of a different worksheet?

Genecks
in Computer Help

Featured Replies

Spreadsheet question: How do I get all the information from a column copied into a column of a different worksheet?

 

Sheet one has Column A with information in it. I want to be able to make changes to information throughout various rows in column A (including deleting and adding new rows with information) and have Column A of Sheet 1 mirrored in Column A of Sheet 2.

 

How do I do this?

 

I'm using Google Docs, but I think it's similar to Openoffice and/or Excel.

  • Author

Like this?

 

Yes, like that, but ='main sheet'!A1 seems to be allowing the copy of one cell per insertion into cell.

 

I seem to be able to copy the column over to another column, thus influencing the same formulas onto nearby columns, thus copying Column B also. This is fine enough. Thank you.

Edited by Genecks

Archived

This topic is now archived and is closed to further replies.

Go to topic listing

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.