Hi guys
Could someone please help me with a macro which would change all values <-10 and <25 to 0 in columns B:BT, but only in those rows where column A contains a specific values like "Parameter1 " and "Parameter2"?
Thank you in advance for your help.
Kind regards
Marek
Last edited by Marq555; 02-02-2015 at 04:20 AM.
Why not simply <25?
<-10 and <25 will be covered when we use <25 right?
Or
Am I missing your logic?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Sixthsense's suggestion makes perfect (Sixth) sense :-)
Following on from that does this work?
Please Login or Register to view this content.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Special-K, thank you for your reply. The provided by you code is missing "))" after <25. Also the Sixthsense's suggestion will not work as I am after the values which falls between -10 and +25.
The data looks as shown on the screenshot below, "Parameter1" = Scheduled Deviation, "Parameter2" = Actual Run Time
Capture.PNG
Regards
Last edited by Marq555; 02-02-2015 at 04:03 PM.
If you want you could use a formula for this " =IF(AND(datasheet!C1>0-10,datasheet!C1<25)=TRUE,0,datasheet!C1) " That would require you to just create a second sheet that is an exact match and then paste that formula into the first cell of the table, then drag and copy that formula across the whole table
Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi daveisalvayshere, thank you for your suggestion. I have already done that but the final result is clunky as it takes a long time for the document to calculate cells.
Regards
Ok no worries, As a project manager i never suggest inputting the data incorrectly or at least have the back up for it....."Was cell B3 a 15 or was it always 0?" its always good to have the data input sheet and an output format if you get what i mean.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks