BEE
What you say is not clear. You say that you have that formula in each
of 50000 cells. Why? Do you want Sheet1 to display every one of those
50000 cells from Sheet2? You say you are copying 6 cells and you give the
addresses of those 6 cells in Sheet2. But then you give only 4 destination
cells in Sheet1. What happened to the other two cell values?
You say that you want to copy the data "arranged in specific requirement."
Is there a pattern to what you want that repeats? If so, provide specific
cell addresses that you want copied to specific cell addresses for at least
2 repeats of the pattern. HTH Otto

"BEE" wrote in message
...
I have 2 Worksheets Sheet1 and Sheet2.

Sheet2 contains the raw data and Sheet1 is the raw data arranged in
specific
requirement.

I have all this formula =IF('Sheet2'!A1="","",'Sheet2'!A1) on every cells
from A1 to D50000

I am copying Sheet2 Cells A1,A2,A3,B1,B2,B3 to Sheet1

A1 is Name1
A2 is Date/Time
A3 is Name2
B1 is Value1
B2 is Value2
B3 is Result.

Copy to Sheet1
A1 is Sheet2.Name1
A2 is Sheet2.Value1
A3 is Sheet2.Value2
A4 is Sheet2.Date/Time

What I did is manually key in the formula in every cells on Sheet1.

May I know how can i do it using a marco.