issue

  1. S

    Phantom tab overlay

    Hello, I have a spreadsheet that's giving me a very strange issue. Sometimes when I paste special values, or change a number being used in a calculation, I get a partial overlay from a different tab on top of my current tab. Here is a screenshot showing the issue: https://imgur.com/a/YG1mfUF...
  2. P

    Checkbox issue

    Hi All, This may be easy for some but I have looked around and can't see an answer to my issue. I have created a form with a number of checkboxes and when I pull the data from access into excel in a table format all the details from the check boxes show ether False or True. Is there anyway...
  3. H

    Converting Excel Files to Adobe Forms

    I have a spreadsheet that I customize, then convert to an Adobe form, then send out to people outside my organization to fill out and return to me. We then enter their info back into the master spreadsheet. I save to PDF, then have Adobe convert it to a form. Generally, everything populates...
  4. C

    Formatting

    Hi All I have a 2 tab spreadsheet Tab 1 is the front facing figures sheet for sales team Tab 2 is the formulas used to work comms at the end of the month Normally I copy and paste no issue But I have mad the row sizes different so when i copy and paste now it doesn't update the cell sizes...
  5. S

    Why the ToggleButtons not working after hide and unhide rows?

    The ToggleButton not working after I hided/unhided the rows. Anyone can help me to fix this issue? many thanks!
  6. N

    Issues With Too Many Formulas and Condition Formulas.

    So I am having an issue with a rather large excel workbook that grows with more information everyday. I currently have 3 formulas running on 3 different columns and I have about 7 conditional formulas that are running, a few that may over lap. This is causing an issue as it slows down the...
  7. D

    SUMIFS Closed Workbook Workaround with Multiple Criteria Array

    Hello, I am having trouble figuring out a way to make this formula work when the source workbook is closed: =SUM(SUMIFS('Workbook A.xlsx]Sheet1'!$E$2:$E$2000,'[Workbook A.xlsx]Sheet1'!$B$2:$B$2000,$A2,'[Workbook A.xlsx]Sheet1'!$D$2:$D$2000,{"Apples","Oranges"})) This formula is working fine...
  8. S

    Copying dynamic Range

    Need a looping macro that will copy a dynamci range from a bunch of excel files and paste into a master file. I can't get the macro to go beyond this line of code and I am not sure what the issue is. Set wb = Workbooks.Open(Filename:=myPath & myFile) Set Rng1 =...
  9. I

    Setting Command Button Properties When Workbook Opens

    Hello, I am currently fighting with the annoying command button/checkbox resizing issue. I put code in that, when clicked, moves the object 1 pixel and then back 1 pixel which has seemed to help the resizing issue during use. However, we are still coming across the issue where the workbook is...
  10. A

    Complicated formula giving "#value" and "You've entered too many arguments for this function"

    Hello, I am trying to figure out why Excel is giving me errors about the new formulas that I am creating. I have an original formula that works and gives me updates: =IF($B$3="(All)",CONCATENATE("Code ",$B$2," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1),CONCATENATE("Code...
  11. S

    text format issue

    I have list of numbers with text formatted, I added plan numbers which is not aligning with same text format how can I do ? old list is left aligned new right Old list 3304277 3304277 3304277 new 3304277 3304277 3304277
  12. D

    VBA Absolute Reference: #REF Errors

    Hello, I one last issue I am trying to solve to complete my project and I am at a loss on how to fix it. Sheet1 = "Inventory Value Report" - I am using this as an "import tab" where a new value report is pasted every time it needs to be used. My issue is that the first macro that runs...
  13. S

    If Statement formula issue without picture issue lol

    Hi all, Last week I was completely stuck with this concept and Kweaver helped me out with this awesome formula, but since then I needed to modify the formula to add another condition and now I cannot get the formula to make S2 = 0 is the other conditions are "Non-Billable" and "No". Below is...
  14. K

    compile error- "user-defined type not defined"

    I was sent a workbook from one of our suppliers and asked to complete it (its a questionnaire.) Whenever someone tries to choose a selction from one of the drop-down boxes on the worksheet (not in a form) we get the 'user-defined type not defined' compile error... same thing happens on any...
  15. K

    Time Issue at Midnight

    I have an issue with a COUNTIF formula once a schedule goes to midnight and after. In column A I have four times; 21:00, 22:00, 23:00 and Midnight. The first formula only looks at A2-A4; omitting midnight: Count, If A2 through A4 is greater than or equal to 9:00 PM, the result is 3; this is...
  16. G

    Selecting different cell to what I click

    Hi, I've made a workbook on 1 PC using Office 365 2016, and now when I open the workbook on my laptop (SurfaceBook) I am getting a really strange issue. When I am clicking a cell it is selecting a different cell to what I click. It is not a mouse issue. For example clicking cell A48 is...
  17. S

    Switching Windows with Different File names

    I feel silly asking this but I just cannot figure it out. I have a macro workbook set up with form control buttons to pick the module you would like to run. The issue I am having is getting the macro to activate a different window regardless of the file name as the file name is different for...
  18. P

    Reconciliation help/formula support required

    Dear ,I need a formula for doing Reco of un-adjusted entries on daily basis for large amount of entries. Please help me to do it with the help of excel formula . Sample as given below :- "Issue CN" Should be formula output :- <tbody> Document of type ZCR6 Formula Required Amount Sold to...
  19. W

    ADODB issue with query on date

    Hello, Can anyone help me with this issue which is driving me crazy. I have a worksheet (not formatted as a table) with a huge amount of data. I wanted to query for data older than a specific date. I wrote the following function (sorry about the "select case", I still need to find a better...
  20. B

    Excel strange visualization problem

    Hello, I hope you can help me with an issue two colleagues of mine have experienced: they opened a xls file and a 50,000 amount appeared as 50 for both of them. Even when clicking on the cell, the amount was shown as 50 in the bar on the top. The amount appeared correctly for me, so I guess...

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