Need help with formula to transfer data within multiple sheets

A

Aberdham

Board Regular
Joined
Mar 8, 2018
Messages
163
Office Version
  1. 365
Platform
  1. Windows
Hi Guys,

I would like to have the values from the Revenue and cost sheet tranferred to the work sheet respectively:

Work sheet
Jan
Serial numberProcess feeRegistration feeProcess costRegistration cost
1235255245+5647-547556485245+5647+54755648
12654254154512
124562
124851
124487
589581C
V156894526-45624526+4562
Revenue sheetCost sheet
Serial number invoice numberDescriptionCustomerAmountSerial number Invoice numberDescriptionCustomerAmount
12352512RD000451Process fee_04.18-06.18.2018_SN_123525A52451235251562Process fee_04.18-06.18.2018_SN_123525A5245
12MD000541registration fee_04.18-06.18.2018_SN_123525A56481895registration fee_04.18-06.18.2018_SN_123525A5648
12RD000457Process fee_04.18-06.18.2018_SN_123525A56474589Process fee_04.18-06.18.2018_SN_123525A5647
12RC000548Process fee_04.18-06.18.2018_SN_123525A5475MJJK-221Process fee_04.18-06.18.2018_SN_123525A5475
12654212RD000452Process fee_04.18-06.18.2018_SN_126542B54151265425652Process fee_04.18-06.18.2018_SN_126542B5415
12MD000542registration fee_04.18-06.18.2018_SN_126542B45122452registration fee_04.18-06.18.2018_SN_126542B4512
12456212RD000453Process fee_04.18-06.18.2018_SN_124562C55411245622154Process fee_04.18-06.18.2018_SN_124562C5541
12MD000543registration fee_04.18-06.18.2018_SN_124562C4125541registration fee_04.18-06.18.2018_SN_124562C412
12485112RD000454Process fee_04.18-06.18.2018_SN_124851D4511248515412Process fee_04.18-06.18.2018_SN_124851D451
12MD000544registration fee_04.18-06.18.2018_SN_124851D25624545registration fee_04.18-06.18.2018_SN_124851D2562
12448712RD000455Process fee_04.18-06.18.2018_SN_124487E54121244874654Process fee_04.18-06.18.2018_SN_124487E5412
12MD000545registration fee_04.18-06.18.2018_SN_124487E451545JJaregistration fee_04.18-06.18.2018_SN_124487E4515
589581C12RD000456Process fee_04.18-06.18.2018_SN_589581CF4514589581C568Process fee_04.18-06.18.2018_SN_589581CF4514
V1568912MD000546registration fee_04.18-06.18.2018_SN_V15689G4526V156892018965registration fee_04.18-06.18.2018_SN_V15689G4526








Any assistance would be greatly appreciated!

Thank you !		12MC000542registration fee_04.18-06.18.2018_SN_V15689G4562352registration fee_04.18-06.18.2018_SN_V15689G4562

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

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

A
  • Question
If, Sumif, aggregate, rows?
2
Replies
11
Views
1K
Aberdham
A

Forum statistics

Threads
1,214,407
Messages
6,119,332
Members
448,888
Latest member
Arle8907

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