infinity
09-16-2006, 10:26 PM
Hello VBaxers,
I have been elected to take on a project at work. I have a spreadsheet that I have developed, that calculates pallet quantities of foil for shipping on a truck. What I want to do is to be able to summarize the items selected on a second sheet based on the conditional formatting of one cell in the record of the first sheet. In other words, I have conditional formats set up, that if Range P16, for example, is greater than 0 then it highlights that entire row in one color and turns the font color to white.
Example: If any cell in range P14:P20, P24, P28:P32... ect. has a font color of white then I want to copy column C,D,E,P,M and J of that row or rows and paste them, in that order, in a summary section on another sheet. I want that data to go to the first unoccupied row in Range C25:P36 on the second sheet.
Or maybe it would be better to do it based on whether there is a value in those ranges?
Example: If any cell in range P14:P20, P24, P28:P32... ect. is >0 then (same as above)
I am trying to do this, if at all possible with formula's rather than macro's. My IT department would rather that I use formula's. They have told me that I can use macro's if I have to, but would rather that I limit them.
I have developed the sheet, and written several formula's and a few macro's for it, and I know what I want the spreadsheet to do, but I am clueless how to get there from this point. If anyone can help, I would greatly appreciate it. Thank you so much, in advance!
I have been elected to take on a project at work. I have a spreadsheet that I have developed, that calculates pallet quantities of foil for shipping on a truck. What I want to do is to be able to summarize the items selected on a second sheet based on the conditional formatting of one cell in the record of the first sheet. In other words, I have conditional formats set up, that if Range P16, for example, is greater than 0 then it highlights that entire row in one color and turns the font color to white.
Example: If any cell in range P14:P20, P24, P28:P32... ect. has a font color of white then I want to copy column C,D,E,P,M and J of that row or rows and paste them, in that order, in a summary section on another sheet. I want that data to go to the first unoccupied row in Range C25:P36 on the second sheet.
Or maybe it would be better to do it based on whether there is a value in those ranges?
Example: If any cell in range P14:P20, P24, P28:P32... ect. is >0 then (same as above)
I am trying to do this, if at all possible with formula's rather than macro's. My IT department would rather that I use formula's. They have told me that I can use macro's if I have to, but would rather that I limit them.
I have developed the sheet, and written several formula's and a few macro's for it, and I know what I want the spreadsheet to do, but I am clueless how to get there from this point. If anyone can help, I would greatly appreciate it. Thank you so much, in advance!