how to copy with a macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DTruong - 29 May 2006 16:01 GMT

- 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.

Reply to this Message

Steve Schapel - 30 May 2006 01:56 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> - I have a range of differents sku # in column G.
> - Each sku# has different data in columns I, J, K, L, M,
[quoted text clipped - 4 lines]
> - Also give me blank if the previous sku has blank in these colums.
> Thank you.

Reply to this Message