![]() |
#1
|
|||
|
|||
![]()
I have a worksheet (No. 1) which has formulae referring to a previous worksheet (No. 2) in the same workbook
Can I transpose the first worksheet (No. 1) and keep the correct referencing for the formulae ? Bob M |
#2
|
|||
|
|||
![]()
Can you upload a file showing what you have and examples of what you want?
|
#3
|
|||
|
|||
![]()
Sure
test file attached Bob M |
#4
|
|||
|
|||
![]()
Maybe like the attached.
|
#5
|
|||
|
|||
![]()
Thank you - exactly what I am seeking...................
I have hundreds of columns to populate Please explain where I actually name the range Bob M |
#6
|
|||
|
|||
![]()
Press Formulas (on the Ribbon) then Name Manager. Press New and write name (for example d) in the Name field. Select the Refers to field and select the relevant range (for example b_1!$A$1:$S$10) and press OK.
|
#7
|
|||
|
|||
![]()
Thank you
I understand perfectly........ Bob M Dunedin, New Zealand |
#8
|
|||
|
|||
![]()
A further question.......................
Currently, new data rows are added to tab 1 as it becomes available For tab 1_b, I simply copy the last row down to produce the extra rows For the b1_transpose tab, how do I accommodate new data columns from tab 1_b as the range is fixed? Bob M |
#9
|
|||
|
|||
![]()
See comments in sheet b_1.
|
#10
|
|||
|
|||
![]()
Thank you
![]() Bob M |
#11
|
|||
|
|||
![]()
I forgot to mention that to expand the table in b_1 you can just select the cell in the bottom right corner (now S10) and press Tab.
I also forgot to mention that the formulas in b_1Transpose at present are copied to A1:J26. You will have to copy these formulas down and to the right as required. In b_1Transpose you can of course use formatting to hide zeros if you want. |
#12
|
|||
|
|||
![]()
Duly noted
![]() Thanks Bob M |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
EdStockton | Excel | 1 | 08-06-2014 11:00 PM |
![]() |
sala-marie | Excel | 3 | 10-27-2013 09:32 PM |
![]() |
samkiewhock | Excel | 1 | 09-06-2012 03:34 AM |
![]() |
meggenm | Excel | 4 | 02-04-2012 02:04 AM |
![]() |
nolesca | Excel | 3 | 06-07-2010 04:02 PM |