New to excel

J

joeangry

New Member
Joined
Jun 25, 2024
Messages
3
Office Version
  1. 365
Platform
  1. Windows
I have 2 worksheets one for vendor invoice and another for customer billing. Need to find the difference and/or combine the to worksheets.
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Sort by date Sort by votes
Provide some sample data 8-10 records using XL2BB and then mock up your solution.
 
Upvote 0
please see example. I need to match up the EE ID, RPT Date and the 2 billed amounts in the first sheet with the invoiced amount in the other sheet
 

Attachments

  • 2024-06-25_21-32-11.png
    2024-06-25_21-32-11.png
    16.4 KB · Views: 7
  • 2024-06-25_21-33-09.png
    2024-06-25_21-33-09.png
    31.6 KB · Views: 6
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question
i need a excel macro to read from several pdf file kept under one folder and put in on a single excel output file
Replies
1
Views
387
ExcelToDAX
E
D
  • Question
Print Multiple invoices in one PDF File
Replies
1
Views
172
John_w
J
J
  • Question
Formula or pivot table needed
Replies
1
Views
130
Fluff
Fluff
I
  • Question
Advice for slight alteration to existing working code
Replies
1
Views
171
ipbr21054
I
I
  • Question
Saved pdf from worksheet doesnt show all the page
Replies
6
Views
182
ipbr21054
I

Forum statistics

Threads
1,221,584
Messages
6,160,642
Members
451,661
Latest member
hamdan17

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