Relating cells in a row in one sheet to cells in columns on another sheet.

mbesspiata3 · #1 01-05-2017, 12:19 PM

I have a row of cells that will be entering data in on one sheet (say A1:A12). I have another sheet in the same workbook with the same data but spread across columns c3:n3. I use these two sheets for updating charts. I currently have to enter this same data information on both sheets. I've been trying to find a way to place a reference to the one sheet so I only have to enter the data once and it updates the other sheet. The issue also is that I can't drag my formula across the cells.

Is there any way to make this work?

xor · #2 01-05-2017, 10:07 PM

There are more ways to do this. One way is shown in the attached.

mbesspiata3 · #3 01-06-2017, 05:42 AM

That seems too simple. Thanks so much for your help.
Greatly appreciated.

Mike

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to populate cells from 1 sheet to another	dnh4wk	Excel	2	12-16-2015 02:33 PM
Setting autofilter criteria using columns and cells relative to the active cell in another sheet	SarahL	Excel Programming	7	06-11-2015 10:26 AM
Copy data from certain Cells in new sheet	zain_shaikh	Excel Programming	1	02-11-2015 07:35 PM
Macros to Re Arrange these Cells to Look like Sheet 2	taimysho0	Excel	2	01-25-2014 11:05 AM
Look up cells in one sheet and add to another	aulrich28	Excel	2	02-26-2013 10:27 AM