help with macro

  • Thread starter Thread starter rjmagana
  • Start date Start date
R

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
 
There is no need for a macro - just use an append query with the Region field
added to the design view grid.
 
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.
 
Back
Top