Christopher Anderson

Posts: n/a

Referencing Problem

I have two worksheets. In sheet 1 I want to reference the cells in the
following way:

Sheet1!A7=Sheet2!A1

Sheet1!A14=Sheet2!A2

Sheet1!A21=Sheet2!A3

Sheet1!A28=Sheet2!A4

etc.

How can you do this in excel. I tried to copy the pattern down but it will
not do it right. Any help would be appreciated!

Chris

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
Row Autofit problem Excel 2003	Matthias Klaey	Excel Discussion (Misc queries)	0	January 19th 05 05:33 PM
Hyperlink to word document problem	JS	Links and Linking in Excel	0	December 8th 04 10:54 PM
Paper Tray selection Problem,	Michael Hoffmann	Excel Discussion (Misc queries)	4	December 3rd 04 09:08 PM
Custom Type Charts Problem	Reetesh B. Chhatpar	Excel Worksheet Functions	0	November 23rd 04 10:55 AM
Problem with Pivot Table Drop-Down Menus	Mac	Excel Worksheet Functions	4	November 7th 04 01:18 PM

All times are GMT +1. The time now is 05:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us