Help needed VBA Copy select cells and add to bottom of list.

**thequiff** · 10-16-2013, 04:17 PM

All I need to do is copy the following

Copy Sheet1(D2) to Sheet2 Bottom of Column C (first cell with no value in)

then the remain to copy to the same row as above

Copy Sheet1(D3) to Sheet2 Column A
Copy Sheet1(D4) to Sheet2 Column B
Copy Sheet1(E39) to Sheet2 Column D

Then Copy the entire Sheet including formatting to a new sheet with the label that is equal to the value of D2 of Sheet 2

Many Thanks

Matt

**alansidman** · 10-16-2013, 05:35 PM

This should work for you

Please Login or Register  to view this content.

Then Copy the entire Sheet including formatting to a new sheet with the label that is equal to the value of D2 of Sheet 2

Copy which sheet?
By label do you mean to name the new sheet with the value in D2?

**thequiff** · 10-17-2013, 02:33 AM

Almost working for me. I've had to change as I have merged cells.

However I need it to paste special only values.

Please Login or Register  to view this content.

Then Copy the entire Sheet including formatting to a new sheet with the label that is equal to the value of D2 of Sheet 2

I need to Copy the sheet 'Invoice' to a new sheet in the workbook with all the formatting and spacing etc. The name of that sheet would be The Value of D2:E2 (merged cell) of the sheet 'Invoice'

Many Thanks

Matt

**alansidman** · 10-17-2013, 07:54 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)