col1

Suppose I have a table like the one below. As it stand now, the data is in D6:G11. I want to define a dynamic named range ("Table") that is, at the moment, D5:G11. If I add a row anywhere between 5 and 12 or a column anywhere between C and H, I want Table to automatically expand. <tbody> R/C C...

Consider the table below <tbody> COL1 COL2 COL3 COL4 EXPECTED RESULT ROW1 100 200 100 300 COL1, COL3 ROW2 200 100 50 400 COL3 ROW3 100 100 100 100 COL1,COL2,COL3,COL4 ROW4 900 900 900 900 COL1,COL2,COL3,COL4 </tbody> as an example i have added just four rows...

I have a data with various combinations (Sample illustration below) where values in col1 and col2 reverses and therefore reports. I am looking for a way flag the reversed duplicates (A-->B and B-->A are same to I just want to keep one record) and ultimately delete the duplicates (#3 and #4 )...

Sub Steps() Dim col(1 To 2) As Variant Dim arr() As Variant Dim x As Long Dim LR As Long col(1) = 2 col(2) = 16 Application.ScreenUpdating = False For i = 1 To 2 For x = 1 To 2 With...

if all 4 qtr is >= 100 then 20000 , if any 3 qtr > 100 and anl > 105 ach% , then 20000 after matching col1 and col2 with the grid <tbody> grid col1 AA A B C ANL XX 25000 20000 16500 13000 105 YY 20000 17000 14500 12000 110 data col1 col2 QTR1 QTR2 QTR3...

I have this code I use to find and replace cell values. I added an If statement to make sure one cell value does not get replaced based on the offset cell. It is not working. Need to know what I am doing wrong. Dim oFindRng As Range Dim Col1 As String Col1 = "A" Columns(Col1).Select...

I have a series of tables on a worksheet, indentical in layout, and I need a VBA function to use a LOOKUP function for any of the tables sent to it. Simplified, the tables look like this: <tbody> Table1 Table2 id col1 col2 id col1 col2 1 a d 1 u x 2 b e 2 v y 3 c f 3 w z </tbody>...

Hi I have data in two spreadsheets as below Sheet 1 Col1 Col2 AAA 01 BBB 02 CCC 01 DDD 03 Sheet 2 Col1 Col2 01 X11 01 X12 02 Y11 02 Y12 02 Y13 03 Z11 I want to match col2 in sheet 1 with Col1 in sheet2 and whenever a match happens i need...