help with macro

[rjmagana]

Hi,
Everyday, I get a file with a list of items and thier prices. I have
to format it several times for different regions, but with the same
data. How would i create a macro to automatically copy the same data
to the four regions.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

 

[Guest]

There is no need for a macro - just use an append query with the Region field
added to the design view grid.

 

[rjmagana]

i want to use excel, though.

 

[Douglas J. Steele]

In that case, you'd probably be better off asking in a newsgroup that's
related to Excel.

This one's for questions about macros in Access, the database product that's
part of Office Professional. Macros in Access are nothing like macros in
Excel.