RETRY Didn't know the JPEG would do that.
Hi I am hoping you guys can help me. I have 2 sheets (SALE) (HOT Items) I want to take things from SALE sheet and have it automatically update on HOT Items sheet. So when ever someone changes something on Sale sheet it automatically updates the HOT Items Sheet. The trick is I don't want every row from the Sale Sheet just the rows that have SALE#### if it says SALE#### Totals or if the cell is blank I don't want that to copy.
I also would like it to order by Sale# then Item
Sorry I can't get pictures or screen shots to up load so the word column is just telling you column a b c and under the column# is the row number but for some reason it is showing in front of the information in column a. So when you are looking below please note ignore the number in front of Sale I was just trying to show I am starting column titles on row 5.
SALE SHEET
Column#
| a
| b
| c
| d
| e
| f
| g
|
Sale #
| Item
| DESCRIPTION
| qty
| Price
| new price
| discount
| |
Sale1701_TOTALS
|
|
| $9.10
| $44.90
|
| | |
Sale1701 | Apples | Some DESCRIPTION 1 | $ 0.50
| $2.40
| | | |
Sale1701 | oranges | Some DESCRIPTION 2 | $ 0.75
| $3.65
| | | |
Sale1701 | Grapes | Some DESCRIPTION 3 | $0.35
| $1.65
| | | |
Sale1701 | Soup | Some DESCRIPTION 4 | $1.25
| $6.15
| | | |
Sale1701 | bread | Some DESCRIPTION 5 | $3.75
| $18.65
| | | |
Sale1701 | milk | Some DESCRIPTION 6 | $2.50
| $12.40
| | | |
| Deal #1 | BOGO free and stuff | | | | | |
| Deal #2 | BOGO free | | | | | |
| | |
| | | | |
Sale1702_TOTALS
| | | $1.60
| $7.70
| | | |
Sale1702 | water | Some DESCRIPTION 1 | $0.50
| $2.40
| | | |
Sale1702 | soda | Some DESCRIPTION 2 | $0.75
| $3.65
| | | |
Sale1702 | pizza | Some DESCRIPTION 3 | $0.35
| $1.65
| | | |
| Deal #1 | BOGO free | | | | | |
| | | | | | | |
Sale1703_TOTALS
| | | $2.85
| $13.85
| | | |
Sale1703 | beer | Some DESCRIPTION 1 | $0.50
| $2.40
| | | |
Sale1703 | wine | Some DESCRIPTION 2 | $0.75
| $3.65
| | | |
Sale1703 | hot dog
| Some DESCRIPTION 3 | $0.35
| $1.65
| | | |
Sale1703 | ranch
| Some DESCRIPTION 4 | $1.25
| $6.15
| | | |
| Deal #1
| BOGO free
| | | | | |
| Deal #2
|
| | | | | |
| | | | | | | |
<colgroup><col><col><col><col><col><col span="2"><col></colgroup><tbody>
[TD="align: right"]5
[/TD]
[TD="align: right"]6
[/TD]
[TD="align: right"]30
[/TD]
[TD="align: right"]7
[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]26
[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]27
[/TD]
[TD="align: right"]28
[/TD]
</tbody>
Hot Items
A B C D E
[TABLE="width: 419"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Sale #[/TD]
[TD]Item[/TD]
[TD]DESCRIPTION[/TD]
[TD]Price[/TD]
[TD]discount[/TD]
[/TR]
[TR]
[TD]Sale1701
[/TD]
[TD]Apples
[/TD]
[TD]Some DESCRIPTION 1
[/TD]
[TD="align: right"]0.5
[/TD]
[TD="align: right"]0.1
[/TD]
[/TR]
[TR]
[TD]Sale1701[/TD]
[TD]oranges[/TD]
[TD]Some DESCRIPTION 2[/TD]
[TD="align: right"]0.75[/TD]
[TD="align: right"]0.1[/TD]
[/TR]
[TR]
[TD]Sale1701[/TD]
[TD]Grapes[/TD]
[TD]Some DESCRIPTION 3[/TD]
[TD="align: right"]0.35[/TD]
[TD="align: right"]0.1[/TD]
[/TR]
[TR]
[TD]Sale1701[/TD]
[TD]Soup[/TD]
[TD]Some DESCRIPTION 4[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]0.1[/TD]
[/TR]
[TR]
[TD]Sale1701[/TD]
[TD]bread[/TD]
[TD]Some DESCRIPTION 5[/TD]
[TD="align: right"]3.75[/TD]
[TD="align: right"]0.1[/TD]
[/TR]
[TR]
[TD]Sale1701[/TD]
[TD]milk[/TD]
[TD]Some DESCRIPTION 6[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]0.1[/TD]
[/TR]
[TR]
[TD]Sale1702[/TD]
[TD]water[/TD]
[TD]Some DESCRIPTION 1[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.1[/TD]
[/TR]
[TR]
[TD]Sale1702[/TD]
[TD]soda[/TD]
[TD]Some DESCRIPTION 2[/TD]
[TD="align: right"]0.75[/TD]
[TD="align: right"]0.1[/TD]
[/TR]
[TR]
[TD]Sale1702[/TD]
[TD]pizza[/TD]
[TD]Some DESCRIPTION 3[/TD]
[TD="align: right"]0.35[/TD]
[TD="align: right"]0.1[/TD]
[/TR]
[TR]
[TD]Sale1703[/TD]
[TD]beer[/TD]
[TD]Some DESCRIPTION 1[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.1[/TD]
[/TR]
[TR]
[TD]Sale1703[/TD]
[TD]wine[/TD]
[TD]Some DESCRIPTION 2[/TD]
[TD="align: right"]0.75[/TD]
[TD="align: right"]0.1[/TD]
[/TR]
[TR]
[TD]Sale1703[/TD]
[TD]hot dog[/TD]
[TD]Some DESCRIPTION 3[/TD]
[TD="align: right"]0.35[/TD]
[TD="align: right"]0.1[/TD]
[/TR]
[TR]
[TD]Sale1703[/TD]
[TD]ranch[/TD]
[TD]Some DESCRIPTION 4[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]0.1[/TD]
[/TR]
</tbody>[/TABLE]
How I need the results to look on HOT Items sheet