D
dravon
I have a list of items with a potentially changing count - sometimes 6,
sometimes 7, etc. These lists are located in a single worksheet,
separated with a blank space. My goal is to create a macro which can
move through this sheet, delete those lists I don't want to keep,
alphabetically sort those I do want to keep, and then copy/paste the
sorted ranges into the final document resting place.
I currently have macros which can count 6 items, another for 7 items,
another for 8 items, etc. I want to replace these individual count
dependant macros with a more dynamic macro. Based on the source log
file, here is the logic that the macro will need to follow:
========
insert new worksheet
Select from A1 to first blank row -- delete selected rows, move rows
up
Select from A1 to first blank row -- sort selection alphabetically on
column A, no header
Narrow selection to B1:F___ -- cut
move to previously inserted worksheet
Select from A1 to first blank cell in Row 1 - paste selection
return to first worksheet
(Repeat this step X times)
============
I'm not married to this logic either, I just tried condencing the steps
down into as generic and simple a process as I could.
I've tried sorting through various excel/VBA help forums, but I don't
need the last blank cell in the entire row - I need the next blank cell
in a series, and then to work with just that data. I'm pretty new to
VBA scripting, so I'm sure this is somewhat of a cakewalk to seasoning
programmers, but to me it's stalled my automated export process for 3
days now. Any suggestions would be ever so gratefully appreciated!
- Sondra
sometimes 7, etc. These lists are located in a single worksheet,
separated with a blank space. My goal is to create a macro which can
move through this sheet, delete those lists I don't want to keep,
alphabetically sort those I do want to keep, and then copy/paste the
sorted ranges into the final document resting place.
I currently have macros which can count 6 items, another for 7 items,
another for 8 items, etc. I want to replace these individual count
dependant macros with a more dynamic macro. Based on the source log
file, here is the logic that the macro will need to follow:
========
insert new worksheet
Select from A1 to first blank row -- delete selected rows, move rows
up
Select from A1 to first blank row -- sort selection alphabetically on
column A, no header
Narrow selection to B1:F___ -- cut
move to previously inserted worksheet
Select from A1 to first blank cell in Row 1 - paste selection
return to first worksheet
(Repeat this step X times)
============
I'm not married to this logic either, I just tried condencing the steps
down into as generic and simple a process as I could.
I've tried sorting through various excel/VBA help forums, but I don't
need the last blank cell in the entire row - I need the next blank cell
in a series, and then to work with just that data. I'm pretty new to
VBA scripting, so I'm sure this is somewhat of a cakewalk to seasoning
programmers, but to me it's stalled my automated export process for 3
days now. Any suggestions would be ever so gratefully appreciated!
- Sondra