Find Jobs
Hire Freelancers

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.
项目 ID: 10415951

关于此项目

10提案
远程项目
活跃8 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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
$30 USD 在0天之内
4.9 (420条评论)
7.6
7.6
10威客以平均价$75 USD来参与此工作竞价
用户头像
Hi, I am good at Excel and vba. I have gone through the requirements. Looking forward to discuss further in the chat.
$34 USD 在0天之内
5.0 (1245条评论)
8.5
8.5
用户头像
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$50 USD 在1天之内
5.0 (499条评论)
8.0
8.0
用户头像
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
$200 USD 在3天之内
4.9 (15条评论)
3.5
3.5
用户头像
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.
$100 USD 在5天之内
5.0 (4条评论)
2.8
2.8
用户头像
Yes it is possible
$55 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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.
$66 USD 在3天之内
5.0 (1条评论)
0.1
0.1

关于客户

UNITED STATES的国旗
Fayetteville, United States
5.0
25
付款方式已验证
会员自9月 21, 2005起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。