forms..reports and filtering

  • Thread starter Thread starter trey
  • Start date Start date
T

trey

i have a form recently completed that id like to link up
to another workbook... the form has numerous drop down
menu/s..etc.. id like to set it up with the other
workbook; so, i can track daily activity with it.. do i
need to go into my form and create " headers " and how
would i then link it up with the other workbook...
plz help
trey
 
Hi Trey,

You can easily do this using VBA. You can have one file to complete
your form and then you can have another file where you'll transfer your
information to and keep as your database.

You could set it up so that after each form you complete you click on a
button and the information is automatically transfered to your database.

I should mention that I'm using a Mac, but the code I have should work
without any problems.

If you're interested, let me know and I'll provide you with the code and
step-by-step instructions.
 
all im looking to do is set it up with another
workbook/sheet so the daily activity can be recorded...
is vb going to be the only way to do this... if so will i
be able to set it up not only for myself; but, for others
as well with it ready to go... let me know...
trey
 
When you said you created a form, I was thinking something else. Now
I'm not sure what you need. Can you provide some more information.
 
my worksheet has numerous drop down/s and other info...
this is a worksheet that will be filled out on average 5
to 10x's a day for different customers... i want the info
to be filtered to another workook ( seperate file ) so i
can have a running tally of the days..weeks..months
activity...etc... what do i need to do to set this up..i
hope this explains in gfreater detail what im trying to
do...
thanks
trey
 
Back
Top