Excel Template Erases Randomly - Macro Problem?

[Kyhosa]

Hi everyone I have 2 spreadsheets.

The Tracker is where you start the basics and then click the command button to generate the form, with some of the fields populated.
From there the form is what is what is worked in until closure. When the form is closed, the command button will be clicked, and will send some of the data back to the tracker and save the form as a PDF.

What I am having issues with, is even though the form is being saved as it is being worked on, the next time it is opened up, all the info is gone including the info that was auto-populated by the tracker. This does not happen every time, but is causing issues. I can't quite figure out where the issue would happen, does anyone have any ideas?

Thanks in advance.

[Squeaky]

hi Kyhosa,
Open the VBA by right clicking on the spreadsheet tab and view the code in the module. Under Debug select Step Into, or press F8. This will run your macro one line at a time. You will need to press F8 in order to make it progress through the Macro. Watch your form to see if you can determine when the info is erased so you can determine the line the code is at that is doing this. Study the line to see if you can find the issue. If not, report it back here and somebody may be able to help.

[Logit]

.
#1 : After reviewing your code in both workbooks, there does not appear to be anything that tells Excel to load data into the FORM when the workbook is opened.

#2 : Question: Why are you using two workbooks when a single workbook would suffice ?

[Kyhosa]

Logit: I used 2 because one of the spreadsheets is more of a general data log that I can pivot on multiple different entries. The other sheet is where detailed data is added, for one item at a time. Does this make sense?

[Logit]

.
I'm confused.

Are you exchanging the terms "Sheet" and "Workbook" for one another ?

When you open Excel it create a single workbook that contains 3 sheets (or worksheets).

Are you working with a single workbook ... with your form on one of the sheets and your collection of data on another sheet ?

Or are you truly using two different workbooks?

[Kyhosa]

Yes sorry, workbook

[Logit]

.
If possible you should use only one workbook - having your form on one sheet and the data on the other sheet.

Again, there is nothing in your code that appears to "load" the data into the form when you open the workbook or the form.

[Kyhosa]

I will work on trying one workbook, just not sure how well that will work for what I need.