Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 15th 12, 07:39 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2012
Posts: 2
Smile Need formula to automatically populate Sheet 2 cells with same content as Sheet 1

Hi everyone,

I have created an Excel document with three worksheets in it. I need Sheets 2 and 3 to have certain columns copied from Sheet 1 (I am entering some information about a group of people, and the "name" and "contact information" columns need to remain the same across all three sheets).

I have been reading through some forums and came across this formula:
=Baseline!C3

However, the problem with this formula is, it requires me to manually change the cell number every time I paste the formula into a new cell. For example, if I need Sheet 1 C4 copied to Sheet 2 C4, I need to go back into the formula and manually change "C3" to "C4," and so on. I need about 200 cells duplicated and manually changing the formula doesn't seem very feasible.

Is there an easier way to get the formula to automatically copy from the next cell, so that every name can be copied, not just the name in C3?

  #2   Report Post  
Old October 11th 12, 08:04 PM
Junior Member
 
First recorded activity by ExcelBanter: Feb 2012
Posts: 21
Default

Quote:
Originally Posted by tanveerksingh View Post
Hi everyone,

I have created an Excel document with three worksheets in it. I need Sheets 2 and 3 to have certain columns copied from Sheet 1 (I am entering some information about a group of people, and the "name" and "contact information" columns need to remain the same across all three sheets).

I have been reading through some forums and came across this formula:
=Baseline!C3

However, the problem with this formula is, it requires me to manually change the cell number every time I paste the formula into a new cell. For example, if I need Sheet 1 C4 copied to Sheet 2 C4, I need to go back into the formula and manually change "C3" to "C4," and so on. I need about 200 cells duplicated and manually changing the formula doesn't seem very feasible.

Is there an easier way to get the formula to automatically copy from the next cell, so that every name can be copied, not just the name in C3?
This may work for you. Click the Sheet 2 tab. Hold down on CTRL while clicking on the Sheet 3 tab. This has grouped these two sheets.

Now select Sheet 2 C4, then press the "+" key. Go to Sheet one and select C4, then hit Enter. This should have put the formula "+Sheet1!C4" in cell C4 of both Sheet2 and Sheet 3. While these two sheets are still grouped, select Sheet 2 again and then copy the formula in C4 down as many rows as needed. The same formulas should fill in the corresponding cells on Sheet 3.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to automatically paste cells from one sheet to another sheet? Jenni Excel Discussion (Misc queries) 1 March 24th 10 11:16 PM
Can cells be copies automatically to Sheet 2 and Sheet 3 Curious New Users to Excel 2 March 12th 07 01:10 PM
can I auto-populate cells on another sheet? [email protected] Setting up and Configuration of Excel 1 March 5th 07 07:41 PM
create a formula in one sheet that would read data from separate sheet automatically QD Excel Discussion (Misc queries) 0 December 8th 06 04:17 AM
HOW DO I AUTOMATICALLY POPULATE AN INVOICE ON SHEET 2 FROM SHEET 1 Sonny Excel Discussion (Misc queries) 1 August 26th 06 04:00 PM


All times are GMT +1. The time now is 06:13 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017