row and column

Hi guys, can you help me. I need a macro for this problem. Thanks in advance! :)

Good day all, I'm attempting to build a dashboard of Incident Ticketing data for our IT office. Every morning I extract a new Incident report from ServiceNow and import that worksheet into the dashboard excel file. I then try to update each row by matching ticket numbers between the new...

I have started to use VBA and I have the following problem. I want to calculate the variance of the 6th and 9th row. Then, 6th and 12th row (yellow). The loop should then calculate the 7th and 10th and 7th and 13th row (beige) Finally, the loop should then calculate the 8th and 11th row, 8th...

I have an Excel file containing two sheets: - `Teams` (which contains details of teams and time schedule of their matches) - `Results` (contains calculation and number of matches and results, etc). What`Results`did is that each game that has launched status on `Teams` it gets on...

Hi Team, Hope anyone can help me, I have column heading fields like New, Old, Exist, Duplicate and each column has its own values and require vba code to get each line separately. For example for product A, if you have value in New and Duplicate amounting $1000 and $2000 respectively then it...

Hi experts, currently I have a data in this format <tbody> H.Freq H.Uncorrect H.Correction H.Corrected H.Limit x x x x x x x x x x x x x x x x x x x x x x x x x V.Freq V.Uncorrect V.Correction V.Corrected V.Limit x x x x x x x x x x Tested xx 30~1000...

<colgroup><col span="5"></colgroup><tbody> <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> 1 1 2 2 3 3 4 4 8 5 9 6 10 7 13 8 14 9...

A1:A10 = Criteria Range 1 B1:B10 = Criteria Range 2 C1:E1 = Criteria Range 3 How to sumif all 3 criteria's are met? Thanks in advance for your help...

Hi, I am on an assignment to count the number of rows which contain specific text and print the value on email. However I'm stuck here Here are my code Public Function First()Dim Source As Workbook Dim Var1 As Integer Dim Var10 As Integer Dim Source2 As Workbook Set Source =...

Using Excel 2003 in XP...I have a database worksheet ("DATA") that I want to copy certain rows of data to multiple worksheets within the same workbook ("KING", "PIERCE", etc.) if it matches the County (e.g. King, Pierce, etc.) of the same worksheet name. Worksheet DATA has 3 header rows and data...

I am looking for a Macro that will make the process in the document as simple as possible. Its currently a lot of manual work and I would like to automate the process. The document involves a two tables in a Matrix form input Volumes and Budget and an out Actuals. In the same document we have...

Hi All, What would be the best way to find the duplicates using values from multiple columns. Example : Concatenate value of columns A & B & C & D & G and find if this combination is repeated across the sheet and return/highlight value of Column A. (The sheet is large like 50,000 rows)...

Hi, Using the code "ActiveWindow.DisplayHeadings = False" I can hide the Row & Column headings of the active sheet but how do I do this for all the sheets within the workbook in one go?

Good morning, I am currently workin with Excel 07 on windows XP Professional and i ran into an issue a couple of days back on a spreadsheet that contains mainly text responses inside of the cells. I am trying to create a subroutine that recognizes the cells that exceed an X number of...

Reverse Column and Row Look-up <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> We have been working all day on a very large cataloging file. <o:p></o:p> We want excel to point to the ROW and COLUMN location by searching a RANGE. <o:p></o:p> EXAMPLE...

Search and combining row and column data <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have been working on this with one other guy for the majority of the day and wondering if anyone has any insight. <TABLE style="WIDTH: 319pt; BORDER-COLLAPSE...