First as a date, want to according to the date of the new SHEET and SHEET paste-CodePudding

A SHEET of the top eight lines of random, line 9 to start first as a date, want to by date SHEET and new points SHEET paste (8 lines before each SHEET paste, line 9 start according to the time SHEET paste) with VBA, how to realize the big hand for help

CodePudding user response:

Last week was to help his wife made similar macros,
Actually recorded a few macros to piece together the basic with respect to OK,
1, understand your sheet inside exactly have a few dates, this according to the different amount of data that has a different approach, according to the date of collection cycle
2, according to the date to create a new sheet, recording a macro, create a sheet on the according to the loop body of step 1
Eight lines before 3, copy to the new sheet, this can record a copy paste macros, but if large volume slow speed, but also the activesheet problem, a little bad control would be an error, suggest using circular cell object assignment way,
4, traversing the data copy into different sheet, or suggest using cell assignment way, of course, there are two, one is inside the loop body of step 1 traversal data source, each dealing with a date sheet, this logic is simple, but to traverse the data source for many times, and the traverse a data source, according to the date field distribution into different sheet, to record a good article in the current record number every sheet,

CodePudding user response:

reference 1st floor chewinggum response:

really help the wife for a while before done similar macros,
Actually recorded a few macros to piece together the basic with respect to OK,
1, understand your sheet inside exactly have a few dates, this according to the different amount of data that has a different approach, according to the date of collection cycle
2, according to the date to create a new sheet, recording a macro, create a sheet on the according to the loop body of step 1
Eight lines before 3, copy to the new sheet, this can record a copy paste macros, but if large volume slow speed, but also the activesheet problem, a little bad control would be an error, suggest using circular cell object assignment way,
4, traversing the data copy into different sheet, or suggest using cell assignment way, of course, there are two, one is inside the loop body of step 1 traversal data source, each dealing with a date sheet, this logic is simple, but to traverse the data source for many times, and the traverse a data source, according to the date field distribution into different sheet, to record a good article in the current record number every sheet,

1, the date is generally not on a regular basis, at least one of the most nearly five, is the first column, all the same format and each same date is next to the
2, can you give a finished product? Own ability to do it is a little difficult

CodePudding user response:

refer to the second floor Gerry_moming response:

Quote: refer to 1st floor chewinggum response:

Last week was to help his wife made similar macros,
Actually recorded a few macros to piece together the basic with respect to OK,
1, understand your sheet inside exactly have a few dates, this according to the different amount of data that has a different approach, according to the date of collection cycle
2, according to the date to create a new sheet, recording a macro, create a sheet on the according to the loop body of step 1
Eight lines before 3, copy to the new sheet, this can record a copy paste macros, but if large volume slow speed, but also the activesheet problem, a little bad control would be an error, suggest using circular cell object assignment way,
4, traversing the data copy into different sheet, or suggest using cell assignment way, of course, there are two, one is inside the loop body of step 1 traversal data source, each dealing with a date sheet, this logic is simple, but to traverse the data source for many times, and the traverse a data source, according to the date field distribution into different sheet, to record a good article in the current record number every sheet,

1, the date is generally not on a regular basis, at least one of the most nearly five, is the first column, all the same format and each same date is next to the
2, can you give a finished product? Their ability to make really difficult

CSDN in general interest free answer problems to
But if you want others to pay for your work, you should pay for it,

CodePudding user response:

reference chewinggum reply: 3/f

Quote: refer to the second floor Gerry_moming response:

Quote: refer to 1st floor chewinggum response:

Last week was to help his wife made similar macros,
Actually recorded a few macros to piece together the basic with respect to OK,
1, understand your sheet inside exactly have a few dates, this according to the different amount of data that has a different approach, according to the date of collection cycle
2, according to the date to create a new sheet, recording a macro, create a sheet on the according to the loop body of step 1
Eight lines before 3, copy to the new sheet, this can record a copy paste macros, but if large volume slow speed, but also the activesheet problem, a little bad control would be an error, suggest using circular cell object assignment way,
4, traversing the data copy into different sheet, or suggest using cell assignment way, of course, there are two, one is inside the loop body of step 1 traversal data source, each dealing with a date sheet, this logic is simple, but to traverse the data source for many times, and the traverse a data source, according to the date field distribution into different sheet, to record a good article in the current record number every sheet,

1, the date is generally not on a regular basis, at least one of the most nearly five, is the first column, all the same format and each same date is next to the
2, can you give a finished product? Their ability to make really difficult

CSDN in general interest free answer problems to
But if you want others to pay for your work, you should pay for it,

QQ remote help achieve some for a fee, RMB 100, QQ red envelope or pay treasure to [email protected]