A macro for copying to new sheets

August 19, 2011 at 17:00:29
Specs: Windows 7
6 columns of Data A to F unkown number of rows each month to be copied to new sheets each month for 12 months to have a permanet record by month. Is this plain enough? to understand what i am trying to accomplish? Each month is a new set of data to be copied to a new sheet ech month.

See More: A macro for copying to new sheets

Report •


#1
August 19, 2011 at 18:22:19
I'm not sure why you started a new thread with these details, but since you did, I'll delete your other thread.

It would also be nice if you actually asked for some help instead of just posting your requirements and expecting us to provide a solution. Most of the volunteers here like good etiquette because, let's face it, we all answer questions for free.

re: "Is this plain enough? to understand what i am trying to accomplish?"

It's better, but it's still not enough information for us to provide anything meaningful.

Keep in mind that we can't see your workbook from where we're sitting. We don't know what column your months are in. We don't know if the sheet is sorted by month or by a full date or not sorted at all. We don't know if you have/want column headers in the monthly sheets. We don't know what you mean by "each month to be copied to new sheets each month for 12 months" Why would each month need to be copied to new sheets? Why multiple sheets?

The only thing we now know is that you have 6 columns of data to to be copied. That's not very much for us to work with.

Do us a favor. Click on the Blue line at the end of this post and read the instructions found via that link. Then post an example of your data so that we will have some of idea of what your workbook looks like.

When you post your example, try to look at it from our point of view and consider everything we might need to know in order to provide a quality solution.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question