Hello,
I am having issues retreving data based on the attatched image. I want to be able to see every value for "Serier" per "Ver". See example Output 1 and output 2 what I am aiming to recreate. Not sure if Excel has the capabilities to retrive information in that way since the cell next to it...
Hi Everyone.
I am a total newbie to Macros, I love them, think they are amazing but have no clue how to use them or make them so I am praying someone out there can help me. I have googled this to hell and back and I'm still none the wiser!
I have an excel document with 5 tabs containing data...
looking for a formula where by i enter a sheet name and it will retrieve values from that specific sheet, all sheets will have the same formatting and cell locations such as names, id, etc.
Application form:
<tbody>
Name
Employee ID
Date Start
Date End
No. Of Days
Reason
Department...
Legacy 400409
Thread
date
lookup between sheets
retrieveretrievecellvalue
sheet
I am in need of the VBA code for the following:
1. I am starting in cell B3 on worksheet "Mapped_Totals"
2. I need to retrieve the last cell value in column B on worksheet "Baltimore". This column has 3 blank cells then a header column labeled "0-30 days" and then the data flows after that...
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.