LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
H/A H/A is offline
external usenet poster
 
Posts: 1
Default Refernce 2 sheets & same columns & rows

Is it possible to do the following...

Sheet 1
Sheet 2
A B C D A B
C D E F G H

2 3 5 5 4 7

1 1 1 1 1 1
80 A 61 2
8 1 # 61 3
6 B 61 4
4 2 62 5


Ok, Sheet 1 has alot of forumlas to get the #'s in Column A, what I am
trying or would like to do is formulate a chart in Sheet 2 C3:H6 that will
format the corresponding numbers from Sheet2 Col A&B and Row 1&2 and place
them in sheet 1 B3,b4,b5,&b6 and return the formulated number from D5 (D5
from sheet 1 is a formula using the numbers retrieved from the columns and
rows in sheet 2 and the columns and rows in Sheet 1....
For example on sheet 1 in the B column i want it to place 61(sheet2 A3) in
Sheet1 B3, a 2 (sheet2 B3) in sheet 1 b5... the C column in Sheet 1 is
referencing where the numbers come from from sheet 2.... so on and so
forth... but i want to do it for the whole sheet...

Is this possible... Does it even make sense?

Thanks


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
how do I chart columns, rows and sheets yorkieshome Charts and Charting in Excel 2 March 8th 09 06:33 AM
Allow Sheets to be Connected by Rows or by Columns miroslj Excel Worksheet Functions 1 December 7th 07 12:07 AM
Circular Refernce Kamal Excel Discussion (Misc queries) 1 February 27th 07 04:07 PM
Using absolute cell refernce and inserting rows ladyhawk Excel Worksheet Functions 10 December 13th 05 10:59 PM
Can I rotate excel sheets so columns are rows & vice-versa (i.e.. JamesR Excel Discussion (Misc queries) 3 January 12th 05 02:18 PM


All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"