Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Fill isuue...
I'm currently working on an excel spread sheet with around 370 sheets. On my
final sheet there's a big list of everything. Each sheet is a parts list for a product, and each product has its own unique id. The list is meant to reference the cell E2 on a sheet and call up the id. If I pull the box with the formulae in (='<sheet name'!E2 )it just increases the cell reference, i.e. E2, E3, E4... and so on and so forth.... Now here's the question - Is there anyway I can change it so that the auto fill increases the sheet name and not the cells. i.e. ='4451'!E2, ='4452'!E2, ='4453'!E2, and so on and so forth. Does anyone know how I can do this? I know it's me being lazy but I'd rather avoid this tedious task... Cheers, -James (Does my question even make sense?) -- "People are strange like that. Steal five pounds and you''re a petty thief. But steal twenty thousand pounds and you''re either a hero or a government." |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Fill isuue...
You could try something like:
=INDIRECT(TEXT(ROW(A4451),"0000")&"!$E$2") in your first cell and then copy down. This will work if all your sheets are named sequentially starting 4451. Hope this helps. Pete On Sep 14, 12:00 pm, James wrote: I'm currently working on an excel spread sheet with around 370 sheets. On my final sheet there's a big list of everything. Each sheet is a parts list for a product, and each product has its own unique id. The list is meant to reference the cell E2 on a sheet and call up the id. If I pull the box with the formulae in (='<sheet name'!E2 )it just increases the cell reference, i.e. E2, E3, E4... and so on and so forth.... Now here's the question - Is there anyway I can change it so that the auto fill increases the sheet name and not the cells. i.e. ='4451'!E2, ='4452'!E2, ='4453'!E2, and so on and so forth. Does anyone know how I can do this? I know it's me being lazy but I'd rather avoid this tedious task... Cheers, -James (Does my question even make sense?) -- "People are strange like that. Steal five pounds and you''re a petty thief. But steal twenty thousand pounds and you''re either a hero or a government." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
Auto Fill | Excel Worksheet Functions | |||
Auto Fill | Setting up and Configuration of Excel | |||
using auto fill edit or fill handel | Excel Worksheet Functions | |||
Auto fill box | Excel Discussion (Misc queries) |