how to copy with a macro

[Guest]

- I have a range of differents sku # in column G.
- Each sku# has different data in columns I, J, K, L, M,
P,T,X,Z,AB,AD,AF,AH,AJ,AL,AN,AP,AR,AT,AV,AX,AZ
- If I enter a new sku in Column G and if it is the same sku that I already
enter previously, how to create the macro to copy the same information in
colums I, J, K, L, M, P,T,X,Z,AB,AD,AF,AH,AJ,AL,AN,AP,AR,AT,AV,AX,AZ
- Also give me blank if the previous sku has blank in these colums.
Thank you.

 

[Steve Schapel]

DTruong,

The focus of this newsgroup is on macro in Access, the database product.
Your question seems to be related to a spreadsheet, possibly Excel.
You will have a better chance of a good answer in an Excel related
newsgroup.