I have data in one worksheet that is tied to a specific date. That data I can get over to another worksheet using formulas...I do so into a specific set of columns I use to catch and then launch that data into a set of database columns for permanent storage. I did this using a recorded macro which moved the data, erased what was in the Work Launch columns and then also erased what was in the source worksheet. Having trouble with next step.
After filling in the source worksheet with date/data which through the formulas now fills the work launch columns, can I now activate a macro/vba to move that data into the storage columns without overwriting what is already there/deciding to move new data to another storage column if the first storage column is already filled with data from the first iteration through the process?
Attached is the document. Source data originally comes from the "Daily Plan" tab. Drop down lists exist for Segment and Customer Name (pick physician first from segment, then choose any physician name)...affiliation will autofill. Then, enter anything in "Action" column.
Move to the "M MD" tab...use the manual date entry in the Work Launch column to assign the same date as was in the "Daily Plan" tab to each of the physicians you selected. This will autofill in the follow-up column of Work Launch section whatever you put in Action on the Daily Plan worksheet.
This is where the new macro/vba/formula is needed to move that info to the next available database storage columns.
Any help much appreciated...including scrapping what I've done and approaching it very differently.