I'm attempting to consolidate a big block of data with two columns and a reference to a month into a summary table and I can't seem to get there.
Essentially I want to sum for example, all the items in the reference table that are CAPEX and Labour for the Month of September into the...
Good Day to all
I am trying to replace below formulas with a macro code.
I have 2 criterias
Criteria 1 : Plate Number like (PN AU 2095)
Criteria 2 : Period like...
I have a problem and in desperate need of help.
I am trying to create an analysis tool to compare the information in two workbooks and return data to the source workbook.
I have two work books, one current and one history that I want to compare and return the status and status date...
Hello! I'm having trouble with this filter macro below. What I want to do is to filter everything except "jan" so I've written all the other months in the criteria. But for some reason it filters everything and the sheet becomes blank. Can anyone help me with this one?
I need to write a formula to sum the values in column A based on a number of conditions, including one that would be the sum of the values in a number of columns.
Using the following example, I would need to add the values in column A if condition 1 = Australia and the sum of the values in...
I'm a beginner at VBA and I need some help.
I'm using three data sets with district data. Some district have the same name so I want to apply an ID number instead of using the district names. I have a numeric ID in one of the data sets. I now want to insert that ID in the two data sets...
I'm pulling my hair out trying to figure this one out. I have a fake mock-up spreadsheet but the forum will not allow me to post attachments.
I am trying to do a nested IF/AND formula that will give me the EXACT name in a specific cell on a different worksheet. Example: "If the obligation...
I have a spreadsheet that that I am trying to run a macro that does an Autofilter on a range Sheets("Criteria").Range("A1:L2").
Here is the VBA code that does the autofilter:
Sheets("Source").Range("A1:L108784").AdvancedFilter Action:=xlFilterCopy, _...
I am new to this forum and looking for some assistance for creating a macro for a process that takes me about a day to complete. Any help would be greatly appreciated. And Thank you in advance!
Below is the table: