hi guys,
ok so i'm quite a newbie with macros and hopefully can get some help here.
basically what i'm trying to do is this. i have an input table, with a whole bunch of project numbers, each with numerous columns. there are multiple records per project number. what i want to do is create one new sheet for each project number and copy the records to those new sheets.
this step alone is giving me issues. what makes it more complicated is that the master table is split into sections, where project number is always in column 1, however after, for e.g. 100 records, there's a few blank spaces, a new table. so while table 1 at the top may be projects under category A, table 2 below may be category B, which need to be differentiated.
is there ANY way to do this, or steps to simplify the process??
ok so i'm quite a newbie with macros and hopefully can get some help here.
basically what i'm trying to do is this. i have an input table, with a whole bunch of project numbers, each with numerous columns. there are multiple records per project number. what i want to do is create one new sheet for each project number and copy the records to those new sheets.
this step alone is giving me issues. what makes it more complicated is that the master table is split into sections, where project number is always in column 1, however after, for e.g. 100 records, there's a few blank spaces, a new table. so while table 1 at the top may be projects under category A, table 2 below may be category B, which need to be differentiated.
is there ANY way to do this, or steps to simplify the process??
