Excel Macro VB Script to delete rows based on cell criteria for selected range of cells
$30-250 USD
已完成
已发布大约 8 年前
$30-250 USD
货到付款
(step-1) I need a macro or VB script for excel that will hide or delete the entire row of a spreadsheet/worksheet based on a criteria of column H. The criteria for column H is this: If column H is not a number between 0 to 200, that entire row containing the value outside the range (0-200) is to be removed (either hidden or deleted). It doesn’t matter which one; delete or hide is the same to me.
(step-2) Secondly, I would like to delete column G. In other words, column H will now be in column G. I don’t care how this is accomplished. Either delete column G or cut column H contents and paste into column G. I have no use for the content originally in column G. Step 2 can happen before step 1, if necessary.
(step-3) Lastly, I need for the above requirements to work for any range of rows I select from column A through H.
(step-4) If possible, can we then clear the contents of columns A, B, E, and F for the initially selected range of cells?
Please see attachment for a visual idea of the project. Note: step-2 is not critical.
I will need the script and instructions on how to install and use the it.
Hello Sir
Im excel VBA macro and formula Expert :)
i can do anything in excel Sir :), i can do this job Sir :)
please give me a chance for doing your job and im able to start doing your job right now
Thank You
Sincerely
Prameswara
I have more than 6 Years of experience in development. I have got handsOn experience working with VB Script and macros and playing with excel.
Please go through my profile for detail.
Thanks
Hi. My name is Aldo Parducci. I have more of 8 years of experience with VBA Im sure I can complete your project with all the requirements you need. Hope we can discuss more details on chat.
Hello Sir, I am interested to work on your project. I am expert in Data Entry, Excel, MS office etc. I am very much heard worker and having enough time to complete your task. As a new freelancer now I am much confident. My first attention is my client’s satisfaction. I know my job and value of time. I promise to submit your task in time.
Thank You Sir.