I want to copy a Column from A3 to end until data is their and paste using the value option in the excel

Help Activities
,
1

I want to copy a column from A3 cell and paste it same column with value option in excel

IMG_20240224_181503
IMG_20240224_1815031920×3169 408 KB

1 Like
2

Hi @Gopi_Krishna1

Can you give sample input and expected output.

Regards

1 Like
3

Use that same thing used for previous one… actually after filtering we have to use this option

1 Like
4

@Gopi_Krishna1

Please provide the input and output samples

1 Like
5

@Gopi_Krishna1

Give me some time bro.

After filtering your rows are getting hidden right. You won’t be able to paste the values from A3 cell. Instead of Filtering the #N/A and blank values delete those rows and remaining values will be pasted as values.

Regards

1 Like
6

Hi @Gopi_Krishna1

My suggestion would be delete the #N/A and blanks values and you will be good to go. I will give the code for that.

Regards

1 Like
7

Proceed in that way you told

2 Likes
8

Give me some time @Gopi_Krishna1

Regards

1 Like
9

Hi @Gopi_Krishna1

Try this:
Input

image
image176×532 4.33 KB

Workflow:

image
image806×1303 60.2 KB

Code:

Sub DeleteNABlankCellsInColumnA()
    Dim ws As Worksheet
    Dim lastRow As Long
    Dim i As Long
    
    ' Define the worksheet
    Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your actual sheet name
    
    ' Find the last row in column A
    lastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row
    
    ' Loop through each cell in column A starting from the second row
    For i = lastRow To 2 Step -1
        If ws.Cells(i, 1).Value = "" Then
            ' Delete the row if the cell value is blank
            ws.Rows(i).Delete
        End If
    Next i
End Sub

Output:
image

The above code will replace the #N/A value with blank value for entire A column and below macros code will Blank cell values and you will have remaining data.

Regards

1 Like