automatically updates sheet 2 when sheet 1 is changed or added to

[justvba]

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


-- removed inline image ---


Sale Sheet


-- removed inline image ---


How I need the results to look on HOT Items sheet

 

[justvba]

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
5	Sale #	Item	DESCRIPTION	qty	Price	new price	discount
6	Sale1701_TOTALS			30	$9.10	$44.90
7	Sale1701	Apples	Some DESCRIPTION 1	5	$ 0.50	$2.40	10%
8	Sale1701	oranges	Some DESCRIPTION 2	5	$ 0.75	$3.65	10%
9	Sale1701	Grapes	Some DESCRIPTION 3	5	$0.35	$1.65	10%
10	Sale1701	Soup	Some DESCRIPTION 4	5	$1.25	$6.15	10%
11	Sale1701	bread	Some DESCRIPTION 5	5	$3.75	$18.65	10%
12	Sale1701	milk	Some DESCRIPTION 6	5	$2.50	$12.40	10%
13		Deal #1	BOGO free and stuff
14		Deal #2	BOGO free
15
16	Sale1702_TOTALS			15	$1.60	$7.70
17	Sale1702	water	Some DESCRIPTION 1	5	$0.50	$2.40	10%
18	Sale1702	soda	Some DESCRIPTION 2	5	$0.75	$3.65	10%
19	Sale1702	pizza	Some DESCRIPTION 3	5	$0.35	$1.65	10%
20		Deal #1	BOGO free
21
22	Sale1703_TOTALS			20	$2.85	$13.85
23	Sale1703	beer	Some DESCRIPTION 1	5	$0.50	$2.40	10%
24	Sale1703	wine	Some DESCRIPTION 2	5	$0.75	$3.65	10%
25	Sale1703	hot dog	Some DESCRIPTION 3	5	$0.35	$1.65	10%
26	Sale1703	ranch	Some DESCRIPTION 4	5	$1.25	$6.15	10%
27		Deal #1	BOGO free
28		Deal #2

<colgroup><col><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>

Hot Items
A B C D E

Sale #	Item	DESCRIPTION	Price	discount
Sale1701	Apples	Some DESCRIPTION 1	0.5	0.1
Sale1701	oranges	Some DESCRIPTION 2	0.75	0.1
Sale1701	Grapes	Some DESCRIPTION 3	0.35	0.1
Sale1701	Soup	Some DESCRIPTION 4	1.25	0.1
Sale1701	bread	Some DESCRIPTION 5	3.75	0.1
Sale1701	milk	Some DESCRIPTION 6	2.5	0.1
Sale1702	water	Some DESCRIPTION 1	0.5	0.1
Sale1702	soda	Some DESCRIPTION 2	0.75	0.1
Sale1702	pizza	Some DESCRIPTION 3	0.35	0.1
Sale1703	beer	Some DESCRIPTION 1	0.5	0.1
Sale1703	wine	Some DESCRIPTION 2	0.75	0.1
Sale1703	hot dog	Some DESCRIPTION 3	0.35	0.1
Sale1703	ranch	Some DESCRIPTION 4	1.25	0.1

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

How I need the results to look on HOT Items sheet