Copy and Paste Value to another worksheet

**poorgirl09** · 05-31-2016, 04:26 AM

Hi All,

Appreciate your help on the below scenarios.
I have a set of data as per attached.
If I want to copy those more than 2000 to another sheet called A, how can I do it by using Macro?
If I add another name in Sheet "B" and is more than 2000, how to make the Macro to copy and paste value to the last row of the data?

Thanks and regards,
poorgirl

**Richard Buttrey** · 05-31-2016, 04:36 AM

Hi,

One way

Please Login or Register  to view this content.

**poorgirl09** · 06-01-2016, 01:16 AM

Hi Richard,

Thanks for your soon reply.
May I know if I want to copy certain column, eg: Amt only, how can I code?

**Richard Buttrey** · 06-01-2016, 06:35 AM

Hi,

I'm going to assume you will want the name and the amount. So:

Please Login or Register  to view this content.

If however you did mean just the amount column then

Please Login or Register  to view this content.

However have you considered using a Pivot Table which will be far more flexible

Copy and Paste Value to another worksheet

LinkBack

Thread Tools

Rate This Thread

Display

Copy and Paste Value to another worksheet

Re: Copy and Paste Value to another worksheet

Re: Copy and Paste Value to another worksheet

Re: Copy and Paste Value to another worksheet

Thread Information

Users Browsing this Thread

Similar Threads

Copy current month named worksheet and paste into a static worksheet

macro for user input then copy cells from worksheet and paste into another worksheet

VBA Match Cell Range to Worksheet Name and copy/paste to respective worksheet

Match Cell Value to Worksheet Name Then Copy/ Paste Range to Worksheet

[SOLVED] Macro to Copy Master Worksheet create and paste in new auto named worksheet

[SOLVED] Copy data from a worksheet and paste to worksheet with a similar worksheet name

Copy data from a worksheet and paste to worksheet with a similar worksheet name

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions