Method 'Range' of object '_Global' failed Error in macro excel 2016

I am new in vba excel coding.I am generating report from sql developer and creating excel files which is attached in first image.
Capture11.PNG

Now I want to create macro and rearrange my result in Excel. For this I have created button as shown in previous image and after clicking on button I want to create new sheet and generate result as in second image.
Capture1.PNG

I have written below code while recording macro but after clicking on button I'm getting error as

runtime error 1004 method range of object _global failed

Below is my vba code:

Please Login or Register  to view this content.

We need to know which line the code fails on - it may be the line containing only Data

A few comments

Please Login or Register  to view this content.

you do not need to select before copying and you can shorthand pasting

Please Login or Register  to view this content.

same as:

Please Login or Register  to view this content.

Hi,

You should please follow the forum rule on cross-posting. This is also posted here- https://stackoverflow.com/questions/...cro-excel-2016

I have made the changes which you have suggested but getting same error as

Method 'Range' of object '_Global' failed Error

in the line

Range("D" & exportStartRow & ":D" & volumeStartRow - 1).Copy Range("F1")

. Previously i was getting error in the same line

Range("D" & exportStartRow & ":D" & volumeStartRow - 1).Select

.

Below is the changed code:

Please Login or Register  to view this content.

Have you cross posted your question anywhere else other than the one xlnitwit mentions in post#5?
If you have, please post a link to all cross-postings here and in the other forum
- you must also post a link back to this thread in the thread linked by xlnitwit
Forum rules prevent me from assisting you further until that has been done
- please confirm below when all is as it should be
Thanks

i have posted the question in below forum link and nowhere else. I have not posted it in any other forum.
https://stackoverflow.com/questions/...ro-excel-2016#

I have deleted that post from that link.I believe there should not be any problem now. Thanks

Thanks
It looks as though the value of one of your row variables is the cause of your problem
Easy way is to use a message box to tell you the value of each variable

In the 2 lines immediately the line with the error

Please Login or Register  to view this content.

Run the code again and hopefully the answer will be in one of the message boxes

Test the value of variable lastRow in the same way
Is there more than one sheet in your workbook?
(Perhaps VBA is looking at wrong sheet)
Do values "export" and "volume" appear in column D?

Do you actually have 'export' or 'column' in column D? It doesn't look like it from the pictures.

sorry i have corrected my code little bit. There was column mismatch and now i have tried like this.

Please Login or Register  to view this content.

But its generating the result bit not correctly. For record_2 is showing in result 2 times.Before record_4 there should be record_3 column. Its generating the result like below after clicking on button. Also also i want to create new sheet once i click on button and generate the result there.
But currently its generating the result in the same sheet.
Capture666.PNG