I have asked on another thread here if something like this was possible... it was proven possible with a Macro but it was written for me. I would like to learn how to do this for myself, but haven't found any online tutorials that would teach me the in's and out's of Macro; just a general "type this, click here, and it'll do this". That is cool and all, but it doesn't teach me what I would like to do, but it teaches what they want to do.
Can anyone here point me towards a resource to teach this to myself?
Is anyone here willing to teach?
What I am trying to accomplish is this...
A workbook that automatically creates lists based on what the workload is for the day.
Column B has a list of item names.
Column C has a list of formulas that correspond to column B.
These two columns are being used as an information bank and does not frequently change.
Column G has a list of items that is within the workload for the day.
This column is filled out manually.
What I am looking for is a macro (I think) that will take the text data in column G and look for it in column B. Then take the formula in column C and copy it to column H.
Thank you for your time!
Can anyone here point me towards a resource to teach this to myself?
Is anyone here willing to teach?
What I am trying to accomplish is this...
A workbook that automatically creates lists based on what the workload is for the day.
Column B has a list of item names.
Column C has a list of formulas that correspond to column B.
These two columns are being used as an information bank and does not frequently change.
Column G has a list of items that is within the workload for the day.
This column is filled out manually.
What I am looking for is a macro (I think) that will take the text data in column G and look for it in column B. Then take the formula in column C and copy it to column H.
Thank you for your time!
