Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I chart columns, rows and sheets | Charts and Charting in Excel | |||
Allow Sheets to be Connected by Rows or by Columns | Excel Worksheet Functions | |||
Circular Refernce | Excel Discussion (Misc queries) | |||
Using absolute cell refernce and inserting rows | Excel Worksheet Functions | |||
Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) |