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

justvba

New Member
Joined
Jan 6, 2017
Messages
41
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
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
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

Sale1701ApplesSome DESCRIPTION 1 $ 0.50
$2.40
Sale1701orangesSome DESCRIPTION 2 $ 0.75
$3.65
Sale1701GrapesSome DESCRIPTION 3 $0.35
$1.65
Sale1701SoupSome DESCRIPTION 4 $1.25
$6.15
Sale1701breadSome DESCRIPTION 5 $3.75
$18.65
Sale1701milkSome DESCRIPTION 6 $2.50
$12.40
Deal #1BOGO free and stuff
Deal #2BOGO free


Sale1702_TOTALS
$1.60
$7.70
Sale1702waterSome DESCRIPTION 1 $0.50
$2.40
Sale1702sodaSome DESCRIPTION 2 $0.75
$3.65
Sale1702pizzaSome DESCRIPTION 3 $0.35
$1.65
Deal #1BOGO free
Sale1703_TOTALS
$2.85
$13.85
Sale1703beerSome DESCRIPTION 1 $0.50
$2.40
Sale1703wineSome DESCRIPTION 2 $0.75
$3.65
Sale1703hot dog
Some DESCRIPTION 3 $0.35
$1.65
Sale1703ranch
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
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,849
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top