Ok-
I have a form template that employees fill out and then save with unique
names (i.e. template is saved as form.xlsx and they save it as form-1.xlsx,
etc). I also have a live spreadsheet that I want updated as employees fill
out the form. I know how to have cell A1 in book 2 equal cell C4 in book 1,
however what needs to happen is when employees fill out the form it
dynamically fills in the live spreadsheet. At the end of the day the
spreadsheet is "emptied" so it can be filled again the next day with new
information.

So basically what I want is to have the information on the form fill in the
spreadsheet and when another person fills out the form that information fills
in the next empty line in the live spreadsheet. Is this possible?
--
~one by one the penguins steal my sanity~

Pretty much no doubt that it can be done, but it'll take some VBA coding
attached to your form to do it. Also, the live workbook would have to be in
a location that all users of the form can reach on your network.

Beyond that, I don't have enough information to provide a more detailed
response.

"moonface" wrote:

Ok-
I have a form template that employees fill out and then save with unique
names (i.e. template is saved as form.xlsx and they save it as form-1.xlsx,
etc). I also have a live spreadsheet that I want updated as employees fill
out the form. I know how to have cell A1 in book 2 equal cell C4 in book 1,
however what needs to happen is when employees fill out the form it
dynamically fills in the live spreadsheet. At the end of the day the
spreadsheet is "emptied" so it can be filled again the next day with new
information.

So basically what I want is to have the information on the form fill in the
spreadsheet and when another person fills out the form that information fills
in the next empty line in the live spreadsheet. Is this possible?
--
~one by one the penguins steal my sanity~