Solved Copying cell reference from one worksheet to another

Dell Latitude e6510 laptop computer (int...
April 25, 2018 at 05:56:33
Specs: Windows 10, 2.3/8
I am trying to copy from one worksheet to another worksheet in Excel 2010. Sheet 1 has the data (cells a1: d6) that I want copied to Sheet 2. I tried ='Sheet1'!a1:d6 but in Sheet 2, I only got the data from cell a1.

Thank you.
Brian W


See More: Copying cell reference from one worksheet to another


✔ Best Answer
April 27, 2018 at 03:51:58
So, your problem is solved, right?

BTW...

You said: "I was able to drag down or across but could not combine these two actions. So I dragged across and then dragged down each column individually."

When you drag A1 along Row 1 to D1 and then release the mouse button, A1:D1 should still be selected. Do not click anywhere else.

Now you can hover over the black square at the bottom of D1 and watch the hollow white cross turn into the small black cross. When you click the black square and drag down, all 4 columns should drag down since all 4 columns were selected.

If you did something so that you "lost" the A1:D1 selection, simply highlight (select) all 4 cells and then drag them all down at once.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03



#1
April 25, 2018 at 06:43:27
In the first destination cell, enter =Sheet1!A1. Then drag the formula right 3 columns, then drag those 4 cells down 6 rows.

Each cell can only reference a single cell, not a Range. When you try to reference an entire Range, you will actually only reference the first cell in the referenced Range.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •

#2
April 25, 2018 at 06:44:49
Don't use a range designation.

On Sheet 2, Cell A1 enter: =Sheet1!A1
Then Drag Down 6 Rows & Drag Across 3 Columns,
should give you what you want.

MIKE

http://www.skeptic.com/


Report •

#3
April 25, 2018 at 13:18:36
DerbyDad03 and mmcconaghy,

Thank you for your responses. I tried them and it did not work.

In Sheet1, I entered alpha data for A1 through D6.
In Sheet2, I entered =Sheet1!A1 in A1 and then did the necessary drags.

All I got was a response for cell A1.

Where did I go wrong?

Thank you.
Brian W


Report •

Related Solutions

#4
April 25, 2018 at 13:53:17
When you Drag you need to grab the little square on the lower right corner of the cell.
Your cursor should change from a fat cross to a very skinny cross like +

See this page, it's for a Mac but it's the same for Win


https://support.office.com/en-us/ar...


MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#5
April 25, 2018 at 14:32:19
When you drag A1 into B1, what formula shows up in B1?

You don't actually have =Sheet1!$A$1 on Sheet2, do you? The $'s would lock the reference to Sheet1!A1.

That's why I'm curious about what formula shows up in B1 when you drag the A1 formula into B1.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •

#6
April 25, 2018 at 15:10:47
DerbyDad,
Sounds like you may have it.

MIKE

http://www.skeptic.com/


Report •

#7
April 26, 2018 at 15:38:30
mmcconaghy,

Thank you for your response.I was able to drag down or across but could not combine these two actions. So I dragged across and then dragged down each column individually.

Thanks again.
Brian W


Report •

#8
April 26, 2018 at 15:40:50
DerbyDad03,

Thank you for your response. On Sheet2, when I drag from A1 to B1 I get Sheet!B1.

Brian W


Report •

#9
April 26, 2018 at 16:18:44
I get Sheet!B1.

You have an error in the formula.

It should be =Sheet1!A1

Your missing the sheet number.

MIKE

http://www.skeptic.com/


Report •

#10
April 26, 2018 at 17:25:38
mmccoghany,

Thank you for your response. In Sheet2 A1, I have =Sheet1!A1 and in Sheet2 B1, I have =Sheet1!B1.

Thanks again,
Brian W


Report •

#11
April 27, 2018 at 03:51:58
✔ Best Answer
So, your problem is solved, right?

BTW...

You said: "I was able to drag down or across but could not combine these two actions. So I dragged across and then dragged down each column individually."

When you drag A1 along Row 1 to D1 and then release the mouse button, A1:D1 should still be selected. Do not click anywhere else.

Now you can hover over the black square at the bottom of D1 and watch the hollow white cross turn into the small black cross. When you click the black square and drag down, all 4 columns should drag down since all 4 columns were selected.

If you did something so that you "lost" the A1:D1 selection, simply highlight (select) all 4 cells and then drag them all down at once.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03


Report •

#12
April 28, 2018 at 05:03:27
DerbyDad03,

Thank you for your assistance. I am now able to highlight and drag the cursor correctly.

Brian W


Report •

Ask Question