| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COPY MACRO
I would like a macro to copy data from sheet 1 to a new book the macro would copy col A to I inclusive and down to include the last row- The last row varies all the time...and that is where I am having trouble. Will someone please help Thanks -- Norton Professional 2004 says this email is clean...believe it |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
COPY MACRO
sub memacro
workbooks.add thisworkbook.sheets("sheet1").range("A2:I65536").c opy range("A1").pastespecial paste:=xlvalues end sub not sure if this will work as I just guessed and typed it into here without checking first. You should workout how to do record macros as they are definately helpfull at getting you started Jase -----Original Message----- I would like a macro to copy data from sheet 1 to a new book the macro would copy col A to I inclusive and down to include the last row- The last row varies all the time...and that is where I am having trouble. Will someone please help Thanks -- Norton Professional 2004 says this email is clean...believe it . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
COPY MACRO
You should always copy/paste your code to here so we will know you are
making an effort. Please do NOT attach a workbook. -- Don Guillett SalesAid Software "PCOR" wrote in message ers.com... I would like a macro to copy data from sheet 1 to a new book the macro would copy col A to I inclusive and down to include the last row- The last row varies all the time...and that is where I am having trouble. Will someone please help Thanks -- Norton Professional 2004 says this email is clean...believe it |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
COPY MACRO
Would you please show mw a macro that would do as requested and show that
line Thanks "Don Guillett" wrote in message ... One way to get the next available row to use in your macro: nar=cells(rows.count,"a").end(xldown).row+1 Guillett alesAid Software "Don Guillett" wrote in message ... You should always copy/paste your code to here so we will know you are making an effort. Please do NOT attach a workbook. -- Don Guillett SalesAid Software "PCOR" wrote in message ers.com... I would like a macro to copy data from sheet 1 to a new book the macro would copy col A to I inclusive and down to include the last row- The last row varies all the time...and that is where I am having trouble. Will someone please help Thanks -- Norton Professional 2004 says this email is clean...believe it |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
COPY MACRO
You should always copy/paste your code to here so we will know you are
making an effort. Please do NOT attach a workbook. -- Don Guillett SalesAid Software "PCOR" wrote in message gers.com... Would you please show mw a macro that would do as requested and show that line Thanks "Don Guillett" wrote in message ... One way to get the next available row to use in your macro: nar=cells(rows.count,"a").end(xldown).row+1 Guillett alesAid Software "Don Guillett" wrote in message ... You should always copy/paste your code to here so we will know you are making an effort. Please do NOT attach a workbook. -- Don Guillett SalesAid Software "PCOR" wrote in message ers.com... I would like a macro to copy data from sheet 1 to a new book the macro would copy col A to I inclusive and down to include the last row- The last row varies all the time...and that is where I am having trouble. Will someone please help Thanks -- Norton Professional 2004 says this email is clean...believe it |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
COPY MACRO
With all due respect...if I had code to cut and paste, I would not be asking
here. I apperciate your help "Don Guillett" wrote in message ... You should always copy/paste your code to here so we will know you are making an effort. Please do NOT attach a workbook. -- Don Guillett SalesAid Software "PCOR" wrote in message gers.com... Would you please show mw a macro that would do as requested and show that line Thanks "Don Guillett" wrote in message ... One way to get the next available row to use in your macro: nar=cells(rows.count,"a").end(xldown).row+1 Guillett alesAid Software "Don Guillett" wrote in message ... You should always copy/paste your code to here so we will know you are making an effort. Please do NOT attach a workbook. -- Don Guillett SalesAid Software "PCOR" wrote in message ers.com... I would like a macro to copy data from sheet 1 to a new book the macro would copy col A to I inclusive and down to include the last row- The last row varies all the time...and that is where I am having trouble. Will someone please help Thanks -- Norton Professional 2004 says this email is clean...believe it |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
COPY MACRO
You didn't indicate that in the OP
The last row varies all the time...and that is where I am having trouble. indicated that you did have code but were having a problem determining the last row. Didn't I give you one solution to determine the last row? try something like this. Modify to suit nar=worksheets("sheet2").cells(rows.count,"a").end (xldown).row+1 range(cells(activecell.row,"a"),cells(activecell.r ow,"H")).copy _ worksheets("sheet2").cells(nar,"a") -- Don Guillett SalesAid Software "PCOR" wrote in message able.rogers.com... With all due respect...if I had code to cut and paste, I would not be asking here. I apperciate your help "Don Guillett" wrote in message ... You should always copy/paste your code to here so we will know you are making an effort. Please do NOT attach a workbook. -- Don Guillett SalesAid Software "PCOR" wrote in message gers.com... Would you please show mw a macro that would do as requested and show that line Thanks "Don Guillett" wrote in message ... One way to get the next available row to use in your macro: nar=cells(rows.count,"a").end(xldown).row+1 Guillett alesAid Software "Don Guillett" wrote in message ... You should always copy/paste your code to here so we will know you are making an effort. Please do NOT attach a workbook. -- Don Guillett SalesAid Software "PCOR" wrote in message ers.com... I would like a macro to copy data from sheet 1 to a new book the macro would copy col A to I inclusive and down to include the last row- The last row varies all the time...and that is where I am having trouble. Will someone please help Thanks -- Norton Professional 2004 says this email is clean...believe it |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If macro to copy a row | Excel Discussion (Misc queries) | |||
| Copy workbook, don't copy macro | Excel Discussion (Misc queries) | |||
| macro copy | Excel Discussion (Misc queries) | |||
| I need a macro that can copy | Excel Programming | |||
Linear Mode
