Paga Mike

Junior Member

Location: Lakehurst, NJ, USA

Posts: 19

Quote:

Originally Posted by Picc

Is it possible to copy and paste a cell with a formula containing a reference to another sheet of data into a cell on another row without incrementing the cell reference?

Sheet1
1A(x)
2A(y)
3A(z)

Sheet2
1A(x)
2A
3A(y)
4A
5A(z)

So that the rows are shipped on sheet2 but the reference is not skipped sheet1.

Thanks

Use the $ sign.

Instead of:

=Sheet2!C6

use:

=Sheet2!C$6

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
AutoFill with Reference incrementing BUT able to delete!	Duane	Excel Worksheet Functions	2	February 11th 10 05:27 PM
How do I Incrementing Cell Reference Values by 7?	Cheri Firlit	Excel Discussion (Misc queries)	3	January 10th 09 09:00 PM
Incrementing cell reference	Paul Mugleston[_2_]	Excel Discussion (Misc queries)	1	January 10th 08 04:06 PM
Incrementing cell reference in Lookup formula	MartinW	Excel Worksheet Functions	3	May 14th 07 01:55 PM
incrementing formula reference by 7	Patti	Excel Discussion (Misc queries)	2	January 20th 05 08:23 PM

All times are GMT +1. The time now is 10:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us