Hi Team,
I have workbook and it contain 5 sheets. my daily activity is .
first , I convert text number to number format. (those are green attached to cell)
I know vba code, but is working for sheet1 only, I unable to run for all sheet.
I am using :=> cells.value = cell.value. and looping this sheet1.range("a1").current region by defining this as range.
but want to do in all sheet.
Step 2) In sheet 1 I want to filter column M, and criteria is "System" and after applying this criteria , I want to delete visibable rows entirely (excluding header) and remove filter.
Step 3) In sheet 2 I want to filter column N, and criteria is "System" and after applying this criteria , I want to delete visibable rows entirely (excluding header) and remove filter.
Step 4) I want to insert column after column a , in sheets. (1,2,4, Respectively) and in that I want apply vlookup.
look up value in that blank column will be a1, criteria will be from other workbook. column 1, exact match. and drop down that formula till last row of column a. this inserting column and applying vlookup I carry it in (sheet1,2,4)
I know little about coding and I understand the code. Can someone help me,
Thanks in advance , for you help and time.
Regards,
Mallesh
I have workbook and it contain 5 sheets. my daily activity is .
first , I convert text number to number format. (those are green attached to cell)
I know vba code, but is working for sheet1 only, I unable to run for all sheet.
I am using :=> cells.value = cell.value. and looping this sheet1.range("a1").current region by defining this as range.
but want to do in all sheet.
Step 2) In sheet 1 I want to filter column M, and criteria is "System" and after applying this criteria , I want to delete visibable rows entirely (excluding header) and remove filter.
Step 3) In sheet 2 I want to filter column N, and criteria is "System" and after applying this criteria , I want to delete visibable rows entirely (excluding header) and remove filter.
Step 4) I want to insert column after column a , in sheets. (1,2,4, Respectively) and in that I want apply vlookup.
look up value in that blank column will be a1, criteria will be from other workbook. column 1, exact match. and drop down that formula till last row of column a. this inserting column and applying vlookup I carry it in (sheet1,2,4)
I know little about coding and I understand the code. Can someone help me,
Thanks in advance , for you help and time.
Regards,
Mallesh