Removing Bolded Rows with Multiple Headings per worksheet.
With a Workbook.xlsm, which had the code assistance of gowflow, and which may have up to six worksheets, for each one, with multiple common headings per worksheet, what is the best way to remove the non-bolded data rows, so that all that is left is the specific bolded data rows, within each worksheet, which would then be manually transfered to a Word document?
Cook09
Cook09
I just noticed your title says:
Removing Bolded Rows ....
and then the text of the question says differently:
what is the best way to remove the non-bolded data rows, ...
So what is it ? Bolded or non Bolded ?
then if we endup with headings and comments and nothing underneath you want to delete the heading as well ? and if the worksheet endup with only the title and few lines shall we delete the whole worksheet ???
Pls be specific by posting a sample.
gowlfow
Removing Bolded Rows ....
and then the text of the question says differently:
what is the best way to remove the non-bolded data rows, ...
So what is it ? Bolded or non Bolded ?
then if we endup with headings and comments and nothing underneath you want to delete the heading as well ? and if the worksheet endup with only the title and few lines shall we delete the whole worksheet ???
Pls be specific by posting a sample.
gowlfow
ASKER
Sorry, It should be removing non-bolded rows. In thinking about it, this really only applies to the Late and Missing. The Posted Late is Late past the 30 minutes, so those are going to bolded. The Misdelivered, doesn't really take "Time" into cosideration, and there should there should be no Error Items.
However, all of the data for the Late and Missing needs to be there within the workbook as it is used for storing and auditing. Clearing the non-bolded, makes it easier to put the bolded ones onto the Word.doc Report.
It would seem to be easier, just to make another worksheet for just the non-bolded Late & Missing rows. But, you can decide that.
I added one additional Late and Missing page to provide an example of why this is beneficial. The "Late and Missing new" provides an example that you wanted. Although, if another worksheet is provided, grouped by Destination, the non-bolded rows could be left off, as long as we have the "original data."
Cook
Error-Log-Report-V02.xlsm
However, all of the data for the Late and Missing needs to be there within the workbook as it is used for storing and auditing. Clearing the non-bolded, makes it easier to put the bolded ones onto the Word.doc Report.
It would seem to be easier, just to make another worksheet for just the non-bolded Late & Missing rows. But, you can decide that.
I added one additional Late and Missing page to provide an example of why this is beneficial. The "Late and Missing new" provides an example that you wanted. Although, if another worksheet is provided, grouped by Destination, the non-bolded rows could be left off, as long as we have the "original data."
Cook
Error-Log-Report-V02.xlsm
In late & Missing New
Row 13,14 15 what do you consider this to be ? bold or not bold
Col A is not bold the rest is
what is the criteria to choose none bolded.
Still you did not answer if a section end up with the header and the row before what we do delete the header or keep the header with no data underneath ?
gowflow
Row 13,14 15 what do you consider this to be ? bold or not bold
Col A is not bold the rest is
what is the criteria to choose none bolded.
Still you did not answer if a section end up with the header and the row before what we do delete the header or keep the header with no data underneath ?
gowflow
ASKER
Row 13,14,15 and any row on this spreadsheet that is primarily bolded, should have been all bolded. I don't know why they weren't.
The bolding criteria is column H, as per the wording under Late & Missing. If the value is greater than 24 hours then the entire row (A:I) should be bolded. Less than 24 hours is not bolded.
If there is no row underneath the header, or just one row that is not bolded, then the header (and row) should be deleted. It serves no purpose just being by itself. Single bolded rows should retain their heading.
My wording was reversed in a comment above, if an extra worksheet is deemed to be the best method, then the bolded rows, with their headers should be on that one, and the (original) can be left as is.
Hope this answers most of what you need.
Cook
The bolding criteria is column H, as per the wording under Late & Missing. If the value is greater than 24 hours then the entire row (A:I) should be bolded. Less than 24 hours is not bolded.
If there is no row underneath the header, or just one row that is not bolded, then the header (and row) should be deleted. It serves no purpose just being by itself. Single bolded rows should retain their heading.
My wording was reversed in a comment above, if an extra worksheet is deemed to be the best method, then the bolded rows, with their headers should be on that one, and the (original) can be left as is.
Hope this answers most of what you need.
Cook
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
gowflow -
The removal of the non-bolded rows seems to work as expected. The original workbook, with all data, even if it's reformatted, needs to be kept for auditing purposes. However, it needs to be saved as a different workbook, due to the removal of the non-bolded data.
I inserted something that would allow the user to save it, if they somehow wanted to save it differently than suggested. But if you have a better process, please delete and insert.
This Save As is also in the orginal reformat code, as the user wants to have the discretion on where the file needs to be saved and/or the name of the file. Normally, they will save as-is, but they want the capability to change either the name or the location. So, accomadations have to be made.
Cook
Error-Log-Report-V03.xlsm
The removal of the non-bolded rows seems to work as expected. The original workbook, with all data, even if it's reformatted, needs to be kept for auditing purposes. However, it needs to be saved as a different workbook, due to the removal of the non-bolded data.
I inserted something that would allow the user to save it, if they somehow wanted to save it differently than suggested. But if you have a better process, please delete and insert.
This Save As is also in the orginal reformat code, as the user wants to have the discretion on where the file needs to be saved and/or the name of the file. Normally, they will save as-is, but they want the capability to change either the name or the location. So, accomadations have to be made.
Cook
Error-Log-Report-V03.xlsm
I do not have a problem but pls sake good order we need to keep threads as short as possible and within the strict frame of the question. As the question here is about non bolded rows to be deleted, pls assess if this was well delivered in this scope then pls close this question and will be glad to assist in any other related or non related question you may need help with.
remember EE is on global search engines and solutions provided can help lots of people having same issues (I am talking in general of course) reason why it is important to keep threads strictly confined to questions and their immediate contents.
Regards
gowflow
remember EE is on global search engines and solutions provided can help lots of people having same issues (I am talking in general of course) reason why it is important to keep threads strictly confined to questions and their immediate contents.
Regards
gowflow
I looked at your code for saving which definitively need reworking especially if what you said about:
The way you are doing it fix half of the problem but still the user is capable to save the present file after the routine has ended and therefore it will no more stay in its original format !!
gowflow
The original workbook, with all data, even if it's reformatted, needs to be kept for auditing purposes.
The way you are doing it fix half of the problem but still the user is capable to save the present file after the routine has ended and therefore it will no more stay in its original format !!
gowflow
ASKER
It fully meets the requirements of what was requested and now everything rolls up into one easy to copy sequence.
if your interested in fine-tuning a save pls post a new question and will be glad to assist.
gowflow
gowflow
ASKER
gowflow,
I think I can live with the saving for the moment...it seems to work, most people just accept the default. There are other items that I'd like to move into that would enhance the overall process, as well as some BI that has been developed over past few months. The first question will involve e-mailing, but that is more of a Word.doc question, but for Excel it will be about appending the Excel database when the bolded rows are created. Then I'll have some questions about Pivots, but will try to keep each question to individual pieces, that will eventually create a whole.
Excel Question:
https://www.experts-exchange.com/questions/28359380/Appending-an-Excel-database.html
Word / Outlook Question:
https://www.experts-exchange.com/questions/28359369/Emailing-a-template-Word-VBA-that-includes-attachments.html
Cook
I think I can live with the saving for the moment...it seems to work, most people just accept the default. There are other items that I'd like to move into that would enhance the overall process, as well as some BI that has been developed over past few months. The first question will involve e-mailing, but that is more of a Word.doc question, but for Excel it will be about appending the Excel database when the bolded rows are created. Then I'll have some questions about Pivots, but will try to keep each question to individual pieces, that will eventually create a whole.
Excel Question:
https://www.experts-exchange.com/questions/28359380/Appending-an-Excel-database.html
Word / Outlook Question:
https://www.experts-exchange.com/questions/28359369/Emailing-a-template-Word-VBA-that-includes-attachments.html
Cook
gowflow