Pratap 1987
Board Regular
- Joined
- Feb 28, 2011
- Messages
- 95
Hi there,</SPAN>
I have a worksheet with Columns A to Y and has filled rows upto 50,000 (maximum). I need a macro to perform the below steps:</SPAN>
- Column P will be titled as "Age" and will have any number between 1 - 50,000. First step of the macro should be to keep numbers between 1 to 5 and delete the other rows (i.e, only keep rows which has number 1 to 5 in Column P)</SPAN>
- Column R will be titled as "Notes" and will have lot of numbers/texts/symbols. Next step of the macro should be bring in a "Input Box" and ask the user to input a value (The user will input a date in the format 0118/0117/anything) - Based on the input, the macro should filter column R which begins with that input date/value and update "Yes" in Column X. Then Remove Filter.</SPAN>
- Column O will be tiled as "NAV Impact" and will have numbers with 5 decimal points. Last step of the macro should be Filter column o which has a value greater than (or) equal to 0.005 and update "Impact" in Column Y. Then Remove Filter.</SPAN>
Your assistance is much appreciated.</SPAN>
Thanks,
I have a worksheet with Columns A to Y and has filled rows upto 50,000 (maximum). I need a macro to perform the below steps:</SPAN>
- Column P will be titled as "Age" and will have any number between 1 - 50,000. First step of the macro should be to keep numbers between 1 to 5 and delete the other rows (i.e, only keep rows which has number 1 to 5 in Column P)</SPAN>
- Column R will be titled as "Notes" and will have lot of numbers/texts/symbols. Next step of the macro should be bring in a "Input Box" and ask the user to input a value (The user will input a date in the format 0118/0117/anything) - Based on the input, the macro should filter column R which begins with that input date/value and update "Yes" in Column X. Then Remove Filter.</SPAN>
- Column O will be tiled as "NAV Impact" and will have numbers with 5 decimal points. Last step of the macro should be Filter column o which has a value greater than (or) equal to 0.005 and update "Impact" in Column Y. Then Remove Filter.</SPAN>
Your assistance is much appreciated.</SPAN>
Thanks,