Hi Everyone,
I really need help writing writing a macro for a function I would like to do.
I have a worksheet with a lot of data.
The following is a layout of an example of what the worksheet looks like:
Vendor Acct 1 Acct 1 Amount Acct 2 Acct 2 Amount ..... Acct 10 Acct 10 Amount
Toy R Us
I need to be able to run the macro and have the information turn into the following:
Vendor Account # Account Amount
Toys R Us Account 1 $$$$$
Toys R US Account 2 $$$$$
....
Toys R Us Account 10 $$$$$
I really need help writing writing a macro for a function I would like to do.
I have a worksheet with a lot of data.
The following is a layout of an example of what the worksheet looks like:
Vendor Acct 1 Acct 1 Amount Acct 2 Acct 2 Amount ..... Acct 10 Acct 10 Amount
Toy R Us
I need to be able to run the macro and have the information turn into the following:
Vendor Account # Account Amount
Toys R Us Account 1 $$$$$
Toys R US Account 2 $$$$$
....
Toys R Us Account 10 $$$$$