Home » Forums » Open Source Learning Center » Question and Answer

Copy row values to multiple sheets

Submitted by andypee on 23 September, 2009 - 02:55

Hi,

I have one Excel sheet with 10,000 rows on it.  I want to copy the first 1,000 rows to sheet1, the next 1,000 rows to sheet2, the next 1,000 rows to sheet3 etc etc.

Can someone please help with the syntax for this.

Cheers.

AttachmentSize
CopyRows.xls561 KB
‹ get file attributes Range To Array ›
»

DOUBT

Submitted by Anonymous on 21 January, 2010 - 18:52.

WHAT IS THE FORMULA FOR CHANGE THE DATE DAY BY DAY AUTOMATICALLY

»
Nick's picture

TODAY()

Submitted by Nick on 22 January, 2010 - 10:02.

You're looking for TODAY()   however, it won't automatically change when the day changes.. you have to prompt it by pressing F9

 

»
JPH's picture

TODAY()

Submitted by JPH on 14 July, 2010 - 14:05.

It will probably automatically change when you open the file. If you have calculation set to automatically that is.

Correct me if i'm wrong

»
Nick's picture

CopyRows

Submitted by Nick on 23 September, 2009 - 09:14.

This will do what you're after..

CopyRows.xls

Nick

»

Not Copying entire Row

Submitted by Anonymous on 14 July, 2010 - 10:52.

Hi,
This macro is not copying entire row. It Is copying only Column A data.

Please upload the excel which will copy the entire row

Thanks,
A.kalusalingam

»

copy rows

Submitted by andypee on 24 September, 2009 - 01:43.

Thanks mate, worked a treat.

Cheers.

»