View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
N! Xau N! Xau is offline
external usenet poster
 
Posts: 2
Default Column-replying macro

Hi all,

I need help with a macro. The macro has to read number N into cell C of
current row, insert N-1 rows under that, and copy values in columns A and B.
For instance:

Befo

A B C
dataA2 dataB2 3
dataA3 dataB3 1
dataA4 dataB4 5
... ... ..

After:

A B C
dataA2 dataB2 3
dataA2 dataB2
dataA2 dataB2
dataA3 dataB3 1
dataA4 dataB4 5
dataA4 dataB4
dataA4 dataB4
dataA4 dataB4
dataA4 dataB4
... ... ..


Thanks a lot for help
N! Xau