VBA Vlookup code in excel

shehla

New Member
Joined
May 22, 2021
Messages
6
Office Version
  1. 2016
Platform
  1. Windows
Hi Everyone,
i need support to write a excel vba code on vlookup of all sheets with different name from first sheet name"Sheet2" and put the information accordingly. number of sheets can vary. number of rows in every sheet can also vary. master sheet"sheet2" cloumns detail can also vary. all sheets numeric numbers will find the data from sheet2 and paste the desire information right above the numeric boxes. picture is attached for reference. looking forward for kind reply.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

shehla

New Member
Joined
May 22, 2021
Messages
6
Office Version
  1. 2016
Platform
  1. Windows
image is attached for reference.
 

Attachments

  • Capture.PNG
    Capture.PNG
    75.8 KB · Views: 8

shehla

New Member
Joined
May 22, 2021
Messages
6
Office Version
  1. 2016
Platform
  1. Windows
how to add vba code to vlookup horizontally and fetch the data from sheet 1 to main sheet
 

Forum statistics

Threads
1,136,322
Messages
5,675,075
Members
419,549
Latest member
EliteBeat

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
Top