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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hi All, I have a strange issue with a dropdown list. I have 3 dropdown list: 1. Dropdown 1 (B5) is independent (static List) 2. Dropdown 2 (C5) is dependent on dropdown 1 (using a named range to get list based on dropdown 1) Named Range Formula: =OFFSET('Drop Down...