Hello,
I'm just learning VBA and having one hell of a time with this problem in VBA. Any help you can give is much appreciated!
I need to copy the entire row for every cell in column A with a certain value then paste to a new sheet. The trick is that the number of values involved is a variable as well as the number of rows that have that value.
For example, say I have a sheet that shows journal entries for a given year. January might only have 1 entry, February might have 6 entries, no entries for March - April, 10 entries in June, etc. And of course this changes from year to year.
So I need a macro to copy the one entry from January to a new sheet called "January", all six entries from February to a new sheet called "February", March - April wouldn't need a sheet since there's no data, all 10 entries on a new sheet called "June" and so forth.
It's probably also important to note that I only used months as an example to explain the issue. It would actually be a 8-digit number of which there are millions of variations.
I don't have enough experience to know where to start. Any direction or examples you can offer would be a great help. Thanks in advance!
Dave
I'm just learning VBA and having one hell of a time with this problem in VBA. Any help you can give is much appreciated!
I need to copy the entire row for every cell in column A with a certain value then paste to a new sheet. The trick is that the number of values involved is a variable as well as the number of rows that have that value.
For example, say I have a sheet that shows journal entries for a given year. January might only have 1 entry, February might have 6 entries, no entries for March - April, 10 entries in June, etc. And of course this changes from year to year.
So I need a macro to copy the one entry from January to a new sheet called "January", all six entries from February to a new sheet called "February", March - April wouldn't need a sheet since there's no data, all 10 entries on a new sheet called "June" and so forth.
It's probably also important to note that I only used months as an example to explain the issue. It would actually be a 8-digit number of which there are millions of variations.
I don't have enough experience to know where to start. Any direction or examples you can offer would be a great help. Thanks in advance!
Dave