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." |
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." |
All times are GMT +1. The time now is 07:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com