How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy, Software Engineer
Category: Programming
Satisfied Customers: 1965
Experience:  Extensive Knowledge in PHP, MYSQL, CSS & Javascript
62934938
Type Your Programming Question Here...
The-PC-Guy is online now

I have a list of Dates from B27 and from C27 I have a list

Customer Question

I have a list of Dates from B27 and from C27 I have a list of names and in D27 I have a list of leave names (Holiday, Sick, Bank Holiday, Bereavement. In excel VBA IF B27+, C27+, & D27+ match Data contained in Cells B25 C25 D25 I would like to delete the row/s only containing the date in all three B25 C25 D25
Submitted: 1 year ago.
Category: Programming
Expert:  The-PC-Guy replied 1 year ago.
please provide an example file of what you want to do.
Customer: replied 1 year ago.

Can you remind me where to upload file

Expert:  The-PC-Guy replied 1 year ago.
wikisend.com ge.tt they all work the same upload file then they give link paste link here
Customer: replied 1 year ago.

Had to try other site as wikisend wouldn't let me upload for some reason so heres the link http://www.filedropper.com/testleave

Expert:  The-PC-Guy replied 1 year ago.
so basically you want to delete any row in which all 3 match? All 3 have to match correct?
Customer: replied 1 year ago.

Yes delete any row where all three B25 C25 D25 have to match.

There may be 2 people with same holiday and you may have too delete one of them so that's why they need to match so you don't delete the other persons hols/Leave

Expert:  The-PC-Guy replied 1 year ago.
i think its doable. I am sending an offer of additional service because it is a bit involved, and I think the question is worth a little bit more. IF you accept it I will get started.
The-PC-Guy and other Programming Specialists are ready to help you
Customer: replied 1 year ago.

Ok do you need contact info

Expert:  The-PC-Guy replied 1 year ago.
nope I will upload the file back to you. Can you access the ge.tt site if I send it there?
Customer: replied 1 year ago.

will try

I can view the ge.tt site

Expert:  The-PC-Guy replied 1 year ago.
http://ge.tt/1Fro4DW2/v/0?c let me know if you have any problems getting the file
The-PC-Guy and other Programming Specialists are ready to help you
Customer: replied 1 year ago.

no problem downloading but am unable to get to the code to use in my main spreadsheet onto the button I want

Expert:  The-PC-Guy replied 1 year ago.
ok, if you can send your whole sheet, I will work on helping you with that

Related Programming Questions