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: 6
  • SHEET 2.jpg
    SHEET 2.jpg
    102.8 KB · Views: 6
  • OUTPUT.jpg
    OUTPUT.jpg
    123.5 KB · Views: 6

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
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
164
etaf
etaf
J
  • Question
Consolidate data from multiple sheets based on values selected in dependent list boxes
Replies
0
Views
294
jconda
J
M
  • Question
Combine pairs of duplicate rows while totalling dollar values for each pair
Replies
1
Views
147
Joe4
Joe4
S
  • Solved
Help with pulling from a report
Replies
4
Views
92
Alex Blakenburg
A
J
  • Question
Macro to load 10 files from different folder into different sheets in Master File
Replies
2
Views
192
joxyin
J

Forum statistics

Threads
1,216,018
Messages
6,128,307
Members
449,439
Latest member
laurenwydo

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