Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Columns To Rows On Another WorkSheet
What I have is a problem very similar to the one you answered for this fellow
except that the data base I'm dealing with needs to elimanate every third row and here is the tough one; the destination is cell interior color dependant. Meaning that every group of three, or 6, or 9 etc. cells in any column that is interior colored by the boss has to go to a specific invoice, like Invoice "Alpine". into two cells next to each other. Example: Buy Report: A B C D E F G H Product Jane Jim Mike Fred Bob Dave SKip #1 10 5 4 6 20 33 100 Price 1.50 1.50 1.50 1.75 1.50 1.25 1.30 boxs 2 1 1 1 4 5 9 #2 Price The Same Down and Over #'s are meaningless Boxs Except that the boxes rows need to be left out #3 of the copy process. I'll use Skips Numbers to Price Represent Three Selected and colored Red Cells Boxs It could be six down or more, but always in threes #4 Price Boxs #5 Price Boxs #6 Price Boxs #7 Price Boxs #8 Price Boxs #9 Price Boxs INVOICE ALPINE Product NUMBERS PRICE TOTALS 100 1.30 40.00 Blue Colored cells would go to Say Ponderosa Invoice. I hope I'm not asking too much. I have gotten cells to copy from columns to rows but its pretty messy and I cant use the cell interior color or eliminate the third row. Part of the problem is that The first group at the top its the fourth row because of the column heading. Column A is also a heading column for rows. I would Also Like it to delete the color in the invoice and then Print when finished |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rows and columns on worksheet | Excel Discussion (Misc queries) | |||
Why can't I add rows or columns on my worksheet? | New Users to Excel | |||
NAMING THE COLUMNS AND ROWS OF A WORKSHEET? | Excel Discussion (Misc queries) | |||
How Do I create a worksheet with rows and columns | New Users to Excel | |||
How Do I create a worksheet with rows and columns | New Users to Excel |