excal

Hi all, I was creating an excel to monitoring the maintenance progress. i would like to hide the row which based on the cell value (date) more than 45days. i have limited knowledge on VBA here is my core. i set the date on colum S, and would like to hide the row base on the value on colum . can...

Hi, i am working on a new employee performance evaluation form. Managers will fill the form for each of their employees semi-annually (attached). Each employee should have a minimum of 5 objectives and a maximum of 10 per each 6-month period. In the old evaluation form, each objective had a...

I'm a complete novice when it comes to Excel and don't know anything unless i can find it on forums i have 3 excel columns that have dates in and i want to use a formula that will highlight dates that are going to be due in six months of the date in the box. i have no idea how or if this can be...

Hi, I am writing to seek your assistance with creating a combo chart in Excel. I need to display both numbers and percentages in the chart, with the line chart showing the percentage values and the column chart showing the number values. I tried creating the chart using the "chart type combo"...

Situation: I have this VBA code that logs any change that is made in the excel sheet and that great; but i need it modified. The plan is to use this in one column as a master change log. But i need a sepret one that will log the window user ID / DATE / Time and lock it to the ROW they edited. So...

When searching I keep finding this code or examples that centers the userForm on the excel window that is open. I want to keep the excel window on 1 screen and have it open the userform on the other monitor of a duel monitor set up. Does any one have suggestions? Private Sub...

I hope you are doing well. I would like to know code available to automate my process to copy one file to another in excel using VBA from two different folder First folder contains excel (.CSV) file with name 01-04-2022_Day.csv, 01-04-2022_Night.csv, 02-04-2022_Day.csv, 02-04-2022_Night.csv, &...

Hello, what is the best way to get rid of 0s for formulas? I have a sum formula and since the cells they reference are blank since its a fresh workbook it is showing 0 and would rather it be blank

Create a sub that records in a list how many times you pressed the return key in the current session (it should write on a new line each time you reopen the file). It should also record the files opening date and times on the same line.

Hi, So I think I have what I need, but it is not working. I am trying to delete all filtered-out rows. (temp1 worksheet is hidden from view) example worksheet: Example.xlsm Option Explicit Public l_DPI_LastRow1 As Long Public s_WeekDayNames1() As String Sub Button1_Click()...

Hello, I am new to VBA and wanted to see if it is possible given a excel file with a sheet of data in it, and using VBA create an xml file? Is there ways or places to look at to get an idea/starting point? New to VBA and creating XML files. Is there a format used with the code, any tips would i...

Hello, I have an excel template with macro that have a 2 sheets: The first contain Table and the second Power Query to this table. I made a button for duplicate the sheet with the table and I want to make a new button that will change the source of the Power Query from the old table to the new...

Hi. I use this code in Excel vba: Dim wdApp As Word.Application wdApp.Documents.Open "E:\Download\planeringsmote.doc" wdApp.Documents(1).InlineShapes(2).Range.Copy wdApp.Documents.Close wdApp.Quit The problem is that Word don't close because Word popup a messagesbox that ask...

Hello - I am trying to save multiple tabs in to a PDF from excel and below is the macro I am using. Macro works fine but would like to add active workbook file name so I don't have to retype the name. ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= Application.GetSaveAsFilename, _...

In VBA I have 3 sheets (output, source,city) city sheet contains 2 column city id and city name .. and my source sheet have random city id .then I have to print city name of those source id in output sheet through array Sub fetch() Dim arr() Dim arr2() last =...

Greetings, I run into problem, when i wanted to test my workbook project... Looking for a solution and suggestion how to make this possible, if its even possible? I tried with Share Legacy, but it can t share macro enabled workbook or workbook with a table... On my network i have one workbook...

Hello, trying to figure out a way to edit the below code to where if the cell is an X then when pasting into the other sheet2 then it goes as "Yes" and if it is blank on sheet1 then it is "No" on sheet2. However the way i have the code it is using xlToLeft and because of that when pasting on 163...

Hello, a bit new to this. 1. Using VBA im trying to see if there is a way to check if a cell has a value, in my case cell G52, if it has a value then copy that cell and the cells to the right of it, so G52 H52 I52. . so on until there is a the last value. 2. Those values that are copied...

Hi all, Can anyone help with a formula which looks up the percentage value in column A sheet 2 against columns A and B in Sheet 1, then looks up column b sheet 2 against columns c and d sheet 1 and then displays the corresponding figure from column E? AB1...

Solve this query....