I have a excel add in that im trying to modify and heres where im stumped. when the user selects the SP function it pulls in any active projects from the user specified time periods and pulls all the pertinent information from a master worksheet called database. i managed to get the program to automatically create the new columns however i cannot get the new columns to store the information i type in them into the database worksheet and pull the information off the worksheet. does anyone have a code example of how to select the columns pertinent values from another worksheet and change them if edited and display them when the SP sheet is opened.

Thank you,

FINCH