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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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
110
Joe4
Joe4
J
  • Question
Macro to load 10 files from different folder into different sheets in Master File
Replies
2
Views
144
joxyin
J
I
  • Question
CountIF alternative for performance improvements
2 3
Replies
21
Views
328
ItalianPlatinum
I

Forum statistics

Threads
1,215,200
Messages
6,123,612
Members
449,109
Latest member
Sebas8956

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