Dear expert
I have formula U:Z i want vba code to run and fill the formula one by one U,V,W,X,Y, When come to Z it has ask Inputbox to enter datevalue, once enter the date, it has to take value of DATEVALUE("mm/dd/yyyy")
if i give 05/31/2015 then this formula has to fill =IF(OR(S2>=DATEVALUE("05/31/2015"),S2=0),G2,"Over Period")
if i give 06/30/2015 then this formula has to fill =IF(OR(S2>=DATEVALUE("06/30/2015"),S2=0),G2,"Over Period")
formula is in sheet afterrunvba
please find the attachment
Last edited by johnmacpro; 07-14-2016 at 03:23 AM. Reason: explain
There's a reference error in the formula in column V. What should this formula actually be?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Sorry sir This is acutal formula =IFERROR(IF(H2="ZSP1",AC2,IF(H2="ZLAB",AD2,IF(H2="LABOR & PART",AC2,IF(AND(H2="LABOR ONLY",G2=""),AD2,TODAY()-S2))))," ")
Okay - try this:
I've cleaned up a couple of your formulas, to use a more efficient LOOKUP instead of so many duplicated nested IF functions.
Please Login or Register to view this content.
Solved Sir Amazing Tricks of code
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks