VBA Code in excel

jatinaroray2k

New Member
Joined
Nov 25, 2022
Messages
4
Office Version
  1. 2021
  2. 2019
  3. 2016
Platform
  1. Windows
Hi,

Please help me with the below, as I have data for 2 different dates and I need a vba code in excel so if i select a date on the dashboard it would populate the data for the given date only.

Thank you in advance.
 

Attachments

  • S1.jpg
    S1.jpg
    155.5 KB · Views: 14
  • S2.jpg
    S2.jpg
    115.5 KB · Views: 15

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Welcome to the MrExcel board!

That would involve a lot of manual typing for a helper to set up and test. MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.
 
Upvote 0
Welcome to the MrExcel board!

That would involve a lot of manual typing for a helper to set up and test. MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.
Hi,

Thank you for your reply.

Please see attached as requested.
1669695413919.png

1669695459932.png
 
Upvote 0
Still getting issues installing XL2BB tool...Is by an chance, can i send an excel file to you
 
Upvote 0
by an chance, can i send an excel file to you
No, that would breach #4 of the Forum Rules

You can upload a sample file (any sensitive data removed or disguised) to DropBox, OneDrive etc and provide a public shared link here. Be aware though that many helpers here choose not to download such files or are prevented from doing so by workplace security.

Still getting issues installing XL2BB tool.
Can you tell us at what point in following through the installation and use instructions that you get stuck and exactly what the symptoms are?
 
Upvote 0

Forum statistics

Threads
1,223,901
Messages
6,175,277
Members
452,629
Latest member
SahilPolekar

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