Hello,
I have created a worksheet with 1000 rows of information that has 12 columns that vary with input information. Each row could have 1 or up to all 12 of the columns entered with information.
I am trying to create a seperate worksheet for each of the 12 columns of information to track ALL the information listed in each row.
Would you please help me to create a formula/macro that will automatically feed the information into the seperate worksheets based on a value entered into each appropriate column.
THANKS!
Ren
Configuration: Windows Vista Internet Explorer 7.0