Macro Formula

D

david2704

Joined
Feb 13, 2009
Messages
1
Reaction score
0
Hi, I want to create a macro to automate my formula every time I entered a job number manually in column A it automate update the formula in column B.
A B
1 job_no Jan-09
2 100018 49,91549

If in cell B2 formula ='M:\job Number\2009-01\[100018- R110104P.XLS]Job_Detail'!D$20

Thanks,
David
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

compare dates with different formats 2
Excel Help with dates 2
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Fill down Formula Automatically 2
Excel formula for counting nr records with data and related empty fields 3
Excel Subtracting multiple columns from another column 3
padding cell with up to 3 zeros 1
Runtime error 1004 when trying to insert formula in cells 11

Top