Copy and paste Macro

Closed

Anon - Nov 27, 2009 at 07:22 AM
Anon - Nov 27, 2009 at 09:29 AM

Hello,

I want to create a macro in VBA - i am a complete novice. I want copy from Sheet 1 - Row2 (always) upto the last populated row, and then paste all this data into sheet 2 into last populated row plus 1 row. Please can you help me ?

thanks

Copy and paste Macro
Spell number in excel without macro - Guide
Macro excel download - Download - Spreadsheets
How to paste photo in resume - Guide
Automatically run a macro when opening a worksheet - Guide
Excel macro to create new sheet based on value in cells - Guide

1 response

Answer 1 / 1

nomadcrys Posts 195 Registration date Tuesday November 18, 2008 Status Member Last seen January 29, 2010 48
Nov 27, 2009 at 09:24 AM

Can you give more details please because i can't seem to find a proper formula for it...

Anon
Nov 27, 2009 at 09:29 AM

basically i have a bunch of data in sheet 1 which i get every day the number of rows varies from day to day, i would like to copy all this data ( row1 holds the column header which i dont need ) all the rows from row2 onwards then paste all this data into sheet 2 but into the last blank row in colum A of sheet 2

Similar discussions

Can no longer paste text into insta

Deleted Message icon

Comparing Two Excel Sheets and copying like data to third sheet

Code for macro that conditionally inserts rows

Copy/paste

Similar discussions

Subscribe To Our Newsletter!