Why and how to resolve. A spreadsheet sent to us by a colleague will not allow a tab/sheet to be hidden. Remedies and reason(s)? Could it have to do with it being a macro enabled sheet?
I have some folks who need to consolidate information spread across 1000 of spreadsheets into one master sheet. I could write a vba solution for some of the workbooks but they are all in different formats and have different information. Therefore, they are copying and pasting the information...
folks, when the number of invoices rejected each month, i generate a report that states the total number of rejections, and the count of each of the possible rejection reasons split out by week. Most reasons are pretty obvious: Cust ID not found, Cust under suspension, etc. to do this, I use a...
Hi there,
I have a sheet with claims. There are different claim reasons and costs.
Here is what I'm working with:
In another sheet, I have the total of $ amount and the different reasons.
Here's what that looks like:
I'm trying to find the % each contributes to the total amount.
Is...
Hi all
when using something like this
msgbox(cells(1,1))
can that only work on the active sheet??
lets say on sheet1 in a1 = have "hello"
but im on sheet 2 when i run the code.
can i have it display the word hello with msgbox(cells(1,1))
i know i can use range(blar balr), i have other...
I have spent a lot of time researching this topic and am coming here as a last resort. Thank you for reading.
A table is for loans and the reasons they were denied. The columns are as follows:
<colgroup><col span="2"><col><col></colgroup><tbody>
Loan#
Narrative
ReasonForDenial1...
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.