work

Hello I used Power query Connection to build the pivot table. The problem I have is that when I move the file to another computer running Excel 2010 or 2013, the pivot table doesn't work properly. My question is, can I add Power query module vba code to the file to work properly on any computer?

I'm trying to reference a filename and path that I've created with a formula. I can't get it to work either in a formula or with a Macro.

I have two tables one that shows all of my work order data and a column called due dates that a user manually updates to assign due dates to a given work order. I have another table called supervisor that has dates that supervisors worked, and any comments they may have added to the table...

Hello, I have a huge workbook with several tabs. I would like to be able to select the tab called "Main" by simply double-clicking anywhere in the spreadsheet. I tried with the code below (ThisWorkbook module) but it does not work :cool: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As...

I have a simple userform setup. i have written code to work on all the userform but what im havint trouble getting to work is: i have 8 diffrent worksheets that i can select what worksheet i place data into. My problem is i cant get the data to go into the first empty cell (Like A1) on the sheet...

Hi please can you help me I have a command button in Book17 where once clicked I want to copy range A1:E2 and paste into 2 other workbooks which are Book16 and Book18, I have the code below but it doesn't seem to work and the lines come up in red, please can you help me? [CODE]Private Sub...

Work Start: 8:00 am Work End :5:00 pm Break Start: 12:00 pm Break End:1:00pm I am trying to compute the working hours with raw data like 08/30/2019 4:00pm - 09/02/2019 9:00am. The result in this one should be 2 hrs only. But if the raw data is 09/02/2019 8:00 am - 09/02/2019 9:00am result...

Hello I have the formula =MEDIAN(SUM(A1,A2),SUM(A3,A4)) and I want to ignore the zeros if any of the SUMs is zero. How can I do this please? I tried =MEDIAN(IF(SUM(A1,A2)<>0,SUM(A1,A2)),IF(SUM(A3,A4)<>0,SUM(A3,A4))) entered as ARRAY but it did not work. Thanks!

Once a month I download a list of workorders for my company and assign X amount of work orders to each group per day (table below). Another table is the list of each and every work order we have. I want to assign work orders based on the amount per day specified in the table below. So on...

I have a macro to pull a row of information from a worksheet upon clicking an icon and posting on the sheet with the Icon. Its been a long time since I used this macro and I have forgotten how I made it work. Can someone tell me what is wrong with this macro? It gives me a runtime error of 1004...

Hi Everyone, I'm using the following formula for working out Students who are above target and it works great. =COUNTIFS($T:$T,">0",G:G,"RE Class 1")/D13 I want to also add to that formula (but I can't get it to work) to only include students "column H:H" with an attendance greater than "95%"...

Need to figure out a fix but have no clue how to do so. I've used this successfully before, really need it to work. Any help is appreciated!

I am a superintendent for a construction company and I have a workbook that I am currently working on and I am fairly new to excel. It is for daily reports in which I have to add 4 pictures everyday for 6 days a week. I found that if I use a chart it will auto re-size pictures for me cutting...

I have a large excel workbook that was made with excel 2003. I am now using Excel 2016. If I "convert" the old worbook to the new 2016 format, is there any downside? (It seems to work fine, but will it work as well with no lags, or issues, when compared to if I made a "new" workbook with...

Hi, This simple formula is driving me nuts. Im trying to create a formula that detects if a a cell is greater than 100 and changes the colour of that cell. I thought this would work: =$K$11>100 Thanks Matt

Hi, Hoping someone can help please, Does co-authoring in excel online (document is stored in office one drive) support cell protection? Id like different users to have specific access to parts of the spreadsheet. But from what I can see this feature doesn't seem to work when editing the...

Hey all, feeling very dumb here. I'm trying to make a simple userform with one textbox, and when the user hits the "Retire" button it will input the data from the textbox into a specific cell (B14 in my case). This feels very simple and I've done it before, but for some reason I can't get it to...

Hi, I have a worksheet where the data has come from an external database...The numbers have come through as text... e.g. '$123,444 How can I convert these to numbers...I've tried using formatting and that doesn't work. Thank you