cmpgeek
12-01-2004, 08:04 AM
is it possible for a macro to make Excel insert a row dependent on the font or fill color of a cell?
as i explained in a previous post, i export results from Crystal Reports to Excel spreadsheets on an almost daily basis. 9 times out of 10, there are extra (empty) rows between each line of data - even if the data should be grouped together.
kpuls and NateO gave me some great suggestions on how to get rid of all the empty rows (thanks guys!); but now i am wanting to find a way to go back through and reinsert an empty row between certain lines...
the particular report i am working on now lists all information on items from a particular product category and is grouped by item description. There are at least 2 -3 lines of information for each item... once i remove all the extra empty rows from the entire report, i want to be able to go back in and insert an empty row between each item (roughly every third line)... what i am wondering if, is i go back in through Crystal and change the font or fill color of a particular field, if once i export the results to Excel, i can remove the extra rows initially, and then have Excel go back through an insert a row below each cell that has in red text or has a colored fill...
i hope this is making some sense... please let me know if i need to explain it better...
as i explained in a previous post, i export results from Crystal Reports to Excel spreadsheets on an almost daily basis. 9 times out of 10, there are extra (empty) rows between each line of data - even if the data should be grouped together.
kpuls and NateO gave me some great suggestions on how to get rid of all the empty rows (thanks guys!); but now i am wanting to find a way to go back through and reinsert an empty row between certain lines...
the particular report i am working on now lists all information on items from a particular product category and is grouped by item description. There are at least 2 -3 lines of information for each item... once i remove all the extra empty rows from the entire report, i want to be able to go back in and insert an empty row between each item (roughly every third line)... what i am wondering if, is i go back in through Crystal and change the font or fill color of a particular field, if once i export the results to Excel, i can remove the extra rows initially, and then have Excel go back through an insert a row below each cell that has in red text or has a colored fill...
i hope this is making some sense... please let me know if i need to explain it better...