Automated Save and worksheet?

D

deeners

How do I set it up to create a new worksheet that pulls the data from
a different sheet or workbook and then save it to a different name? Is
that possible?

Thanks!
 
J

Jim Gordon MVP

Hi,

Yes, it is possible. A variety of technologies can be used for this.

Pulling data can be done using ODBC. Saving can be done via AppleScript or
Visual Basic for Applications.

Can you give us more information about the data source, what kind of data
you wish to pull from the source, and whether or not you are comfortable
with AppleScript or Visual Basic, and whether or not you need to share this
solution with other computers or just on your Mac.

Thanks.

-Jim


How do I set it up to create a new worksheet that pulls the data from
a different sheet or workbook and then save it to a different name? Is
that possible?

Thanks!

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 
D

deeners

I need to create a database for work. We need each case manager to
have their own database and by boss wants one that compiles all the
data so he can keep tabs on it in one worksheet. We use windows at
work and I have a mac at home. I am new to vba and apple scrips but
willing to learn.

Thanks,
:D
 
B

Bob Greenblatt

I need to create a database for work. We need each case manager to
have their own database and by boss wants one that compiles all the
data so he can keep tabs on it in one worksheet. We use windows at
work and I have a mac at home. I am new to vba and apple scrips but
willing to learn.

Thanks,
:D
Search help for consolidate, and shared workbooks. Either or both in
combination seem like what you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top