Copy & Paste "Equal" Function: Adding Distance

  • Thread starter Thread starter nicolairob
  • Start date Start date
N

nicolairob

I'm hoping someone can help me with the following:

1). In (sheet 2, cell A1) I use the Equal formula to make it "= sheet 1,
cell A1"

2). Still in Sheet 2: I copy & paste (cell A1) into (cell A2). Of course,
my result will be "= sheet 1, cell A2) as the formula will maintain my
original distance.
*However, I need the result to be "= sheet 1, cell A6." How can I
do this - get it to "skip" cells so to speak?

Any Help will be most appreciated and save me a considerable amount of time
in hard keying formulas in.
Rob
 
Hi nicolarirob;

The simplest way to overcome the issue is to go to sheet A and copy the cell
you want to appear in sheet B. Then in Sheet B use the Paste Special / Past
Link choice to past link the cell instead of typing in the = formula. Then
you make each cell in sheet B arrange how ever you want.

I hope it helps,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Progressive number in different sheets 7
Run two macros for two different sheets 11
Excel Need Countifs Formula Help 0
Altered pasting functionality 3
Copy columns and paste with blank column between 5
Modify working code to expand the output. 5
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Create if partial match then copy and paste data from one cell to another 1

Back
Top