replace data based on column between two sheets

A

abdo meghari

Active Member
Joined
Aug 3, 2021
Messages
469
Office Version
  1. 2019
hello
I would match data in sheet entry into column C with sheet In & Out Balance into columns C,D,E together based on column B . if the items in column C for sheet ENTRY then should replace data based on sheet In & Out Balance after match based ion column B

sheet In & Out Balance
Bridgestone Stock Sales report (1).xls
BCDE
2CategorySizePatternOrigin
3PSR (LRD)-100175/70R13B25INDO
4PSR (LRD)-101175/70R13EP150THI
5PSR (LRD)-102185/70R13EP150INDO
6PSR (LRD)-103175/65R14EP150THI
7PSR (LRD)-104175/65R14B25INDO
8PSR (LRD)-105175/70R14EP150THI
9PSR (LRD)-106175/70R14MY02THI
10PSR (LRD)-107185/65R14TECTHI
11PSR (LRD)-108185/65R14EP150INDO
12PSR (LRD)-109 185/65R14150EZINDO
13PSR (LRD)-110195/70R14150EZTHI
14PSR (LRD)-111185/65R15TC10INDO
15PSR (LRD)-112185/65R15T005INDO
16PSR (LRD)-113185/65R15T01JAP
17PSR (LRD)-114185/65R15B250JAP
18PSR (LRD)-115195/60R15AR20INDO
19PSR (LRD)-116195/60R15EP150THI
20PSR (LRD)-117195/60R15T001JAP
21PSR (LRD)-118 195/60R15150EZTHI
22PSR (LRD)-119195/65R15MY02THI
23PSR (LRD)-120195/65R15EP150THI
24PSR (LRD)-121195/65R15EP150JAP
25PSR (LRD)-122195/65R15T001JAP
26PSR (LRD)-123195/55R16EP300THI
27PSR (LRD)-124205/55R16 RE003THI
28PSR (LRD)-125205/65R15EP150INDO
In & Out Balance

sheet ENTRY
Bridgestone Stock Sales report (1).xls
BCD
1CATEGORYBRANDSALES
2PSR (LRD)-100BS 175/70R13 INDO$200.00
3PSR (LRD)-110BS 195/70R14 150 INDO$100.00
4PSR (LRD)-111BS 185/65R15 TC10 JAP$120.00
5PSR (LRD)-112BS 185/65R15 T00 INDO$230.00
6PSR (LRD)-113FS 185/65R15 T01 JAP$240.00
7PSR (LRD)-105BS 175/70R15 EP150 THI$100.00
8PSR (LRD)-106BS 175/70R14 02 THI$120.00
9PSR (LRD)-107BS 185/65R14 TEC THI$100.00
10PSR (LRD)-109BS 185/65R14 150E INDO$140.00
11PSR (LRD)-108BS 185/65R15 EP150 INDO$150.00
12PSR (LRD)-101BS 175/70R13 EP150 THI$160.00
13PSR (LRD)-102BS 185/70R14 EP150 INDO$170.00
14PSR (LRD)-103BS 175/65R15 EP150 THI$180.00
15PSR (LRD)-104BS 175/65R14 B25 $190.00
16PSR (LRD)-114BS 185/65R15 B250 INDI$300.00
17PSR (LRD)-115BS 195/60R15 AR20 INDI$400.00
18PSR (LRD)-116BS 195/60R15 EP150 THI$500.00
19PSR (LRD)-117BS 195/60R15 001 JAP$600.00
20PSR (LRD)-118BS 195/60R15 150EZ THI$700.00
21PSR (LRD)-119BS 195/65R15 THI$800.00
entry


I wish this result in sheet ENTRY
Bridgestone Stock Sales report (1).xls
BCD
1CATEGORYBRANDSALES
2PSR (LRD)-100BS 175/70R13 INDO$200.00
3PSR (LRD)-110BS 195/70R14 150 INDO$100.00
4PSR (LRD)-111BS 185/65R15 TC10 JAP$120.00
5PSR (LRD)-112BS 185/65R15 T00 INDO$230.00
6PSR (LRD)-113FS 185/65R15 T01 JAP$240.00
7PSR (LRD)-105BS 175/70R15 EP150 THI$100.00
8PSR (LRD)-106BS 175/70R14 02 THI$120.00
9PSR (LRD)-107BS 185/65R14 TEC THI$100.00
10PSR (LRD)-109BS 185/65R14 150E INDO$140.00
11PSR (LRD)-108BS 185/65R15 EP150 INDO$150.00
12PSR (LRD)-101BS 175/70R13 EP150 THI$160.00
13PSR (LRD)-102BS 185/70R14 EP150 INDO$170.00
14PSR (LRD)-103BS 175/65R15 EP150 THI$180.00
15PSR (LRD)-104BS 175/65R14 B25 $190.00
16PSR (LRD)-114BS 185/65R15 B250 INDI$300.00
17PSR (LRD)-115BS 195/60R15 AR20 INDI$400.00
18PSR (LRD)-116BS 195/60R15 EP150 THI$500.00
19PSR (LRD)-117BS 195/60R15 001 JAP$600.00
20PSR (LRD)-118BS 195/60R15 150EZ THI$700.00
21PSR (LRD)-119BS 195/65R15 THI$800.00
entry

the real data about 1100 rows
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Sort by date Sort by votes
sorry guys the result in sheet ENTRY should be
Bridgestone Stock Sales report (1).xls
BCD
1CATEGORYBRANDSALES
2PSR (LRD)-100BS 175/70R13 B25 INDO$200.00
3PSR (LRD)-110BS 195/70R14 150EZ INDO$100.00
4PSR (LRD)-111BS 185/65R15 TC10 INDO$120.00
5PSR (LRD)-112BS 185/65R15 T005 INDO$230.00
6PSR (LRD)-113BS 185/65R15 T01 JAP$240.00
7PSR (LRD)-105BS 175/70R14 EP150 THI$100.00
8PSR (LRD)-106BS 175/70R14 MY02 THI$120.00
9PSR (LRD)-107BS 185/65R14 TEC THI$100.00
10PSR (LRD)-109BS 185/65R14 150EZ INDO$140.00
11PSR (LRD)-108BS 185/65R14 EP150 INDO$150.00
12PSR (LRD)-101BS 175/70R13 EP150 THI$160.00
13PSR (LRD)-102BS 185/70R13 EP150 INDO$170.00
14PSR (LRD)-103BS 175/65R14 EP150 THI$180.00
15PSR (LRD)-104BS 175/65R14 B25 INDO$190.00
16PSR (LRD)-114BS 185/65R15 B250 JAP$300.00
17PSR (LRD)-115BS 195/60R15 AR20 INDO$400.00
18PSR (LRD)-116BS 195/60R15 EP150 THI$500.00
19PSR (LRD)-117BS 195/60R15 T001 JAP$600.00
20PSR (LRD)-118BS 195/60R15 150EZ THI$700.00
21PSR (LRD)-119BS 195/65R15 MY02 THI$800.00
entry
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
rearranging columns by reversing in location and create headers
2 3
Replies
20
Views
338
Alex Blakenburg
A
A
  • Solved
add specific character in the beginning of item into column
Replies
9
Views
451
Fluff
Fluff
A
  • Solved
replace item for range with item for Table based on column
2
Replies
13
Views
678
Legacy 143009
L
A
  • Question
delete unmatched item for two sheets with another two sheets and put the similar to adjacent
Replies
1
Views
323
abdo meghari
A
A
  • Question
insert column to auto-number for each item into two sheets
Replies
0
Views
230
abdo meghari
A

Forum statistics

Threads
1,215,945
Messages
6,127,840
Members
449,411
Latest member
adunn_23

Share this page

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