Excel help req'd

[Andy™]

have many worksheets in an excel file. first is named 'home', all others are named with a number

in each of the ones with a number, there is some information id like on the 'home' sheet.

so really, i want whats in sheet 101 boxes C2, C3 and C4 to appear on home page in B2, C2 and D2. then from sheet 102 boxes C2, C3 and C4 to be on home page B3, C3 and D3. i also want column A to be the number of the other sheet. all numbers are consecutive so A2 will be 101, A3 will be 102 and so on

Any idea how to do this?

 

[Apache]

Dead easy, type = into the cell you want the number to appear in then go to the sheet you want, select the cell and click enter

The techie way is

=Sheet2!A7

where Sheet2 is the name of the sheet and A7 is the cell

so =sheet102!C2 etc

 

[Andy™]

Dead easy, type = into the cell you want the number to appear in then go to the sheet you want, select the cell and click enterThe techie way is

=Sheet2!A7

where Sheet2 is the name of the sheet and A7 is the cell

so =sheet102!C2 etc

ideally i want it to look at column A for the number in that, and use that to find the page number. so if '=sheet102!C2', is in B2, i want it to look at A1 and use the number from there.

slight change from original post, there may be a few numbers missing!

 

[Apache]

ideally i want it to look at column A for the number in that, and use that to find the page number. so if '=sheet102!C2', is in B2, i want it to look at A1 and use the number from there.slight change from original post, there may be a few numbers missing!

I'm lost by what you want?

Are you wanting to copy a single number to more than one place or gather some numbers together?

I'm lost?

 

[Andy™]

if i put the formula you gave me in cell B2, rather than have '###' in the formula for the other worksheet, i want it to look to cell A2 for the number

 

[Apache]

if i put the formula you gave me in cell B2, rather than have '###' in the formula for the other worksheet, i want it to look to cell A2 for the number

type an = in the box sheet you want the number to appear, select the box where it is, click on it and press enter

eg sheet 1 has a list of numbers 1-9 A1-A9 cell A10 is the sum of the above

to copy the sum of cells A1-A9 to sheet 2 A1 I did as I said and '45' appears in box A1 on sheet 2

the formula from the bar at the top is =Sheet1!A10

If I alter the numbers on sheet 1 the sum on sheet 1 updates as does the copy cell on sheet 2?

Am I still not getting you? You can email me the spreadsheet if you want?

 

[Apache]

### can mean number too large to fit in box? Have you tried making the box bigger?

 

[Andy™]

### can mean number too large to fit in box? Have you tried making the box bigger?

i put the ### to mean 'number' (im good at causing confusion)

so in column A, i have numbers. i.e A2 is 101, A3 is 102 etc. i have worksheets, which are named after these numbers.

now the formula you gave me before works if i type '101' into the formula in B2, but because i want to copy/drag it, and the numbers have some missing (i.e there may be no 109), i want it to look to the box to the left and use the number from there as the worksheet name to find

so in box A2 i will have a number, i.e 101. in box B2 i want ='{get number from A2}'!A7 rather than ='101'!A7

 

[Apache]

trial and error?

I'm happy you emailing me a copy and I can have a play?

 

[jl-heating]

wow goes right over my head this 1 lol.

 

[Andy™]

and mine!