View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sinner Sinner is offline
external usenet poster
 
Posts: 142
Default Column re-arrange in a worksheet (Macro help)

Hi,

I have some data in sheet3.
In sheet4, I want to do the following:

Example:
- columnA of sheet3 values in columnH sheet4
- columnB of sheet3 values in columnK sheet4
and so on. I have almost 21 columns to re-arrange to get the report
that I want.

I have done that with simple = cell in sheet4 for sheet3 but since
data range in sheet3 varies so I have to update sheet4 cells.

Also the calculation time slow.

Some code in back ground can be useful.

Any help is appreciate.