Hi All,
I'm new here but figured some of you might be able to assist: I have been working with a excel file that has a large amount of macros written into it. In short, it takes 2 separate files that I receive everyday (csv and xls) and creates relationships between the two to make a pivot...
Hi, everybody
I am not sure this is the correct forum to ask my question. But any help can orient me towards the solution.
I am developing a VB.NET Sub which can get data from SQL Server to my Excel Sheet at lightning speed (using ADODB connection).
My Sub is written in VB.NET, not VBA. But I...
Is it possible to import a spreadsheet with an if statement?.
Example:
I need to import a spreadsheet from a list if I select a certain category.
If Cell A2 = any from the following list, Project, Open, Closed, All. I need it to import that list spreadsheet.
I know i can nest if statements in...
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.