excel & macro

i have three columns : department id, names , holiday hours > 10 different department id >n number for names and at the end has a 'total' > holiday hours need to be put in the same row as the total of the department what i need help for? i need a macro in which it looks for the department id...

Hi, I have a ComboBox embedded in a worksheet that references a list of items. Ie: small cat cat big cat small dog dog big dog Right now when I type in 'cat' i only get 'cat' as the suggestion. What I would like is to get all items that contain 'cat'., ie., in this case: small cat cat big...

Hi, I'm using Excel 2016 64-bit and have a ComboBox with a dropdown that contains 150+ lines. I'm trying to set it up so that I can scroll through the lines with the mouse wheel.

I have been away form VBA coding for 10 years and am having a problem. I have copied and adapted this subroutine from a google search. It worked 3 days ago, but now is not finding the files in the same folder. I need help in determining why. The part that errors shows a Msgbox with "Run-time...

<tbody style="border-bottom-color: rgb(36, 39, 41); border-bottom-style: none; border-bottom-width: 0px; border-image-outset: 0; border-image-repeat: stretch; border-image-slice: 100%; border-image-source: none; border-image-width: 1; border-left-color: rgb(36, 39, 41); border-left-style: none...

Starting in cell B5, search ROW for "Current Month". In this column starting in cell below "Current Month" Header (L6 this time), create a formula that references one column to left of this column, "=K6".This formula will continue down the column until the last row. This column will change every...

I have managed to get to grips with creating an email and adding the text i need including leaving in the default signature. However what i need is to create 3 new macros with different text in an email but including a 4x2 table in the middle of the text. because of the number of variable...

Hello, I hope my request is possible. I need to create a code to go through the data on a spreadsheet and create chart for each product block. There are might be multiple product blocks. I got code to create the first one, but I am pretty bad with loops and have no idea how to make it go...

Hi, i want to merge data from all workbooks in a folder by using the VBA, i found the example on the https://www.rondebruin.nl/win/s3/win008.htm. It is very useful then i want to modify the code that suit my need but i do not know how to revise the code. Could anyone can tell me that how to...

Hi Guys, I am having an VBA Error 91 using below codes and it stopped in " If none_lastrow.Row > na_lastrow.Row Then" Thanks in advance for the help. :) =========================== Sub NONE() 'Set conditional formatting Set None_check_tab = Workbooks("Data Macro").Sheets("NONE...

Hi all, Please help to run this formula if the day in cell C2 value is saturday Range("F2").Formula = "=IF(AND(D2>=TIME(9,16,0),D2<=TIME(11,59,0)),D2-TIME(9,0,0),IF(AND(D2>=TIME(14,16,0),D2>=TIME(12,00,0)),D2-TIME(14,0,0)*1,0))" and if Cell C2 value is Sunday to Friday...

I have data in even row i would like to copy data from even row and paste into odd row and loop goes to last row of sheet. <tbody> A B C 1 2 Data1 Data1 Data1 3 4 Data2 Data2 Data2 5 6 Data3 Data3 Data3 7 </tbody> <tbody> A B C 1 2 Data1 Data1 Data1 3...

I am currently working on an excel workbook that is pulling in a list of roughly 1000 reports going to a bunch of different emails. It is setup as Sheet: "ReportValues" Column A being Report Titles and Columns B-Q having all the different emails that the reports are sent to. I am trying to make...

Hi all, Is there a macro i can use to add and remove pivot table data fields "values". When adding i would require it to be by average. I'm a bit of a VBA noobie so would be grateful for any help on this. Thank you in advance.

Hi all, I'm currently using this code to toggle pivot table row fields, there are buttons on my spreadsheet that I click to add/remove row fields in the pivot table. This works great, however I was wandering if it is possible to adapt the code to toggle pivot table data field "values" by...

I am trying to compare two file. I receive a file once a week. And I need to compare last week’s file to this week’s file. I have them both in the same file on two different tabs. One called Old and the other is called New. I need to look at these two file and see where the Location has...

Is it possible to use TRIM where the field lengths are not consistent? I need to remove the first character of a field but the length varies between 4 and 8 characters, so wondered what the options were please.

I need to interpolate data from my table and I already have a way of doing so, which I learned from: https://www.engineerexcel.com/bilinear-interpolation-excel/ However, I wanted to incorporate it to my workbook in a way it can automatically fill in the values, since I have many similar tables...

Hi, I have an excel sheet where i want to put a mark on. After that i will extract those data on the line to a new sheet. It is difficult to explain but take å look at the file. The number is å productnumber, second is description, third is the product price, the fourth is the number how many...

Hi, I have an excel sheet where i want to put a mark on. After that i will extract those data on the line to a new sheet. It is difficult to explain but take å look at the file. The number is å productnumber, second is description, third is the product price, the fourth is the number how many...