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 Andy Your Own Question

Andy, Computer Consultant
Category: Computer
Satisfied Customers: 5316
Experience:  11yr exp, Comp Engg, Internet expert, Web developer, SEO
Type Your Computer Question Here...
Andy is online now
A new question is answered every 9 seconds

Good PM -I have developed a spdsht track of my bills with

Customer Question

Good PM
-I have developed a spdsht for keeping track of my bills with col for payee, one for "X" to allow me to clear specific due dates & amounts, a col for 10 days before the due date, a due date column, and a running bal col
-I have the macro to clear the "due date" & "amt" column but that is like driving a tack with a hammer
-I entered a column for "X" which was to be the method of identifying the "due date & amt column to clear but I cannot get the formula either as an interactive entry i.e. when I enter X it clears the due date & amt column. that leaves the X in the X column
-perhaps a macro or VBA pgm to do that is better at the end of a session of bill paying
-can you please assist me/
thanks Bill Palmer
Submitted: 8 months ago.
Category: Computer
Expert:  The-PC-Guy replied 8 months ago.

please send example file

Customer: replied 8 months ago.
I sent pdf- did I do it correctly so u received it?
Bill Palmer
Expert:  The-PC-Guy replied 8 months ago.

would need an actual xls file if possible cannot modify pdf

Customer: replied 8 months ago.
Expert:  The-PC-Guy replied 8 months ago.

sorry don't understand the question.

if you sent me xls file, it would be easier