1. R

    Opening a Workbook from a File Dialog Box

    I would have thought that this should be fairly straight forward but I'm running into issues on opening additional workbooks from a userform. So yes, I have a userform with a button that when clicked opens up a number of additional workbooks. Is this a problem with the string sent to...
  2. A

    VBA code for Text Diff between two columns?

    Hi friends, I need big help on the following. I have two columns with texts. Column A has the old text and Column B has the new text. I need to match these two and show in a 3rd column the additional characters (highlighted in red color) in B column compared to A column text. Further in D...
  3. M

    Protected workbook - Lock More Cells

    Hi, I have a workbook which has a number of projected cells by default. I want to create a VBA that will enable me to press a button that locks certain additional cels, is this possible? Thanks, Matt
  4. D

    Pivot Table Headache 2 -popping sheets

    Here is my Pivot table Part 2 issue. multi sheets will appeared when clicks are done on the Pivot Overview sheet values. Ques: is there any method or ways to "control or deal with" such additional sheets from appearing ? Or we just have to manually deleted any sheets thats pop up after...
  5. T

    Unhiding a Group of Rows Using If/Then Statements

    I am attempting to create a form in Excel for our sales to to request quotes to our office. I currently have a list of products in a drop down and each of those items require additional cells to be completed. Is it possible to create an if/then from a drop down that would unhide the additional...
  6. O

    Export Excel CSV to MS word with specific table format

    Im a bit out of my comfort zone with excel so was wondering if someone can point me in the right direction of how this could be accomplished? We have a CSV file that contains multiple columns, some rows however have additional columns that need to be inside that specific row ONLY and not...
  7. M

    How to pull data based on 74 specific criteria

    I am not sure if this is possible in Access or Excel for that matter... In my data I have a field Client PO. I am working on a project where I need to pull all line items associated with about 74 different PO #. There will potentially be additional lines of data added with these PO's. So I...
  8. A

    Really need some formula help please .....

    Hi folks. I’m having a major meltdown and need to get this sorted for work. Have asked around the office and our IT dept but they say they don’t have time to work this out ( read it’s too difficult!! ) I am conducting a survey at work and the answer to the questions is either a “yes” or “no”...
  9. C

    Changing KM to MPH

    I could really use some help with this. Is there a way to change KM to MPH on this 2010 Excel spreadsheet adding 2 additional columns and some formula...Really stuck HELP
  10. B

    how to get Date Picker in userform

    Can somebody tell me how to get the calender control in the UserForm? I don't find it in my additional tools
  11. H

    ListView in Additional Controls - Not Found

    Hi Experts, I am unable to find the ListView control in Additional Control or in Toolbox of Userform. I surfed thru Google and tried a few steps still unable to find it. Please help me where did I go wrong or is their any other solution for this? In our office, we are using: MS Office 2016...
  12. S

    help with returning incremental values

    Hello, I need help with a spreadsheet that involves safety ratios of kids to adults based on grade ranges. So for instance, if a group of kids is between K and 1st , they need 2 adults for every 12 kids. If there were 24 of them, they would need 4 adults. I have a list of over a 1,000 groups...
  13. apgmin

    Loan mortgage table

    Can anyone please make a loan mortgage table for maximum 10 years @ 9.75% interest p.a. calculated monthly Actually there are a lot of templates for this. But I need the following features 1. there should be provision for extra loan repayment by the borrower in any month possible 2...
  14. S

    How to use object variables in .Formulas VBA

    Hi guys! Long time reader, first time poster :D I've created a quote calculator for our company and having trouble getting costs for a specific products summed up into one cell. I'm trying to write a formula in excel VBA to sum specific values from different worksheets. I have 2 different...
  15. J

    Dynamic Ranges/Array in Vlookup

    Hello, I have a range of sells as part of my Array lookup: A2:D6; However, I would like to make this array dynamic so if additional rows are created (and if possible, additional columns), the range updates automatically. Is this doable without VBA? TIA J
  16. J

    Conditional Formula, I think?

    Hello: I am trying to write a formula to calculate per diem based on the number of days that someone worked AND add an additional day if the person worked 5 or 6 days. Right now I have the following to just count the number of days they have worked: =COUNTIF(R14:X14,"<>0>) This returns the...
  17. G

    Multiple IF statements in a VLOOKUP.

    I am sure this will be very easy, but I am screwing something up in my text. I have this, which works, but I need to add an additional IF statement for <=0. I know this is probably very simple, so any help is appreciated. =IF(VLOOKUP(F1:F30, [Book2]Sheet1!$A$1:$H$2630,8,0)>=0, "YES", "NO")
  18. D

    Return the next and previous multiple of 1000.

    Hello all. I am looking for a way to find an integers (stored as a variable) nearest multiple of 1000's, both above and below. For example, if a variables value is 5012, I would like to have 5000 and 6000 returned as two additional variables. Any ideas?
  19. B

    Return value in text string between "\"

    I have had a troll through and cannot seam to find any answers to a resolution for thew below scenario. I have multiple text strings with "" in varying locations.Generally up to 1000 rows of which there are text strings withing the "" that I wish to retain. ENQUIRY-01-01-08-18\W_SC-Lightning...
  20. T

    Automatically transfer data to next sheet

    Hello all I have two different sheets and want the raw input I add into the first one to automatically transfer in to the same cell on the next sheet and in to a formula. E.g I have written =-‘Sheet1’!A1 in sheet2 to get the first input transferred and change sign, but when I add more...

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
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 "".
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