Consolidated report from two different sheets

B

BINOYFALCON

New Member
Joined
Jul 18, 2023
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
Dear All,
Please help.... I have two reports (sheet 1 and sheet 2) i need the out put like attached.
how to copy the text V, A, SL from SHEET 1 to SHEET 2.
this is more than 100 employees data and report for one year
 

Attachments

  • SHEET 1.jpg
    SHEET 1.jpg
    49.3 KB · Views: 5
  • SHEET 2.jpg
    SHEET 2.jpg
    102.8 KB · Views: 5
  • OUTPUT.jpg
    OUTPUT.jpg
    123.5 KB · Views: 5

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Sort by date Sort by votes
Cannot manipulate data in a picture. Please use the MrE functionality of XL2BB to upload your sample data.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
INDEX MATCH from two sheets onto third sheet?
Replies
1
Views
114
etaf
etaf
J
  • Question
Consolidate data from multiple sheets based on values selected in dependent list boxes
Replies
0
Views
223
jconda
J
M
  • Question
Combine pairs of duplicate rows while totalling dollar values for each pair
Replies
1
Views
112
Joe4
Joe4
J
  • Question
Macro to load 10 files from different folder into different sheets in Master File
Replies
2
Views
145
joxyin
J
I
  • Question
CountIF alternative for performance improvements
2 3
Replies
21
Views
330
ItalianPlatinum
I

Forum statistics

Threads
1,215,214
Messages
6,123,664
Members
449,114
Latest member
aides

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