Hi,
Everyday, I get a file with a list of items and thier prices.How would i create a macro in EXCEL to automatically copy the same data to four regions. This can be anywhere in the sheet and the item and price need to be in the same columns.For example:
item# price
5555 10.00
6666 20.00
7777 30.00
8888 40.00

I would have to do the same with regions 1,2,3,and 4
item# region price
5555 1 10.00
6666 1 20.00
7777 1 30.00
8888 1 40.00
5555 2 10.00
6666 2 20.00
7777 2 30.00
8888 2 40.00
5555 3 10.00
6666 3 20.00
7777 3 30.00
8888 3 40.00
5555 4 10.00
6666 4 20.00
7777 4 30.00
8888 4 40.00

Please also give a description of WHY you are doing this and WHAT you are ultimately trying to accomplish. What kind of file is this? Where does it come from? There may be a few middle-men we can take out here if you give us more details about what it is and why you are doing it.

You can also unprotect the area when te VBA runs the form and re-protect it when it is finished.

What format does the pricing list you receive come as (.txt, .xls, etc.)

If the price list comes to you as Excel format are the item number and price in the same cell or are they in seperate columns?

Will the item number, price, and region all be in seperate columns or in the same cell?

Regards,
Rollin

i got it thanks everyone!

If you would like either a better solution, advice as to how to better use your data or additional information which may be pertinent to your situation that you are not aware of, then answer my questions.

If, however, you're not interested, please post your solution so that other may benefit from it.