G
Guest
Guest
Hi guys,
Here's the problem.
I'm working with a rather complicated excel worksheet, which pulls its values from other worksheets, depending upon the value entered in its criteria field.
for eg: if i were to enter Job #112 in the criteria cell, it would pull all relevant data (from wherever) and post it on the work sheet. I need to do this for about a 100 different jobs. Hence need for a macro.
these job #s can be found in a range on some other worksheet.
Here's my question:
I want to be able to pull all the relevant data for a particular job, save the worksheet with a unique name (say JobNo####.xls), and then carry on doing this for each job.
Pls Help.
appreciate it.
thks a lot folks.
Here's the problem.
I'm working with a rather complicated excel worksheet, which pulls its values from other worksheets, depending upon the value entered in its criteria field.
for eg: if i were to enter Job #112 in the criteria cell, it would pull all relevant data (from wherever) and post it on the work sheet. I need to do this for about a 100 different jobs. Hence need for a macro.
these job #s can be found in a range on some other worksheet.
Here's my question:
I want to be able to pull all the relevant data for a particular job, save the worksheet with a unique name (say JobNo####.xls), and then carry on doing this for each job.
Pls Help.
appreciate it.
thks a lot folks.