Excel Formulas

[vickynh]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a worksheet that I consider to be a "master" worksheet that has detail data, and a second worksheet that pulls summary data from the "master" . Every day, I enter data into the detail "master" worksheet and then save it as a new worksheet named "Detail <Current Date>" and I also save the second worksheet as "Summary <Current Date>".

The next day, I must clear out the detail "master" before I begin entering new data. Is there anyway to automate this? My first thought was to record a macro, but I then discovered that macros are not available.

Vickynh

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a worksheet that I consider to be a "master" worksheet that has detail
data, and a second worksheet that pulls summary data from the "master" . Every
day, I enter data into the detail "master" worksheet and then save it as a new
worksheet named "Detail <Current Date>" and I also save the second worksheet
as "Summary <Current Date>".

The next day, I must clear out the detail "master" before I begin entering new
data. Is there anyway to automate this? My first thought was to record a
macro, but I then discovered that macros are not available.

Vickynh

Macros or AppleScript is the only way to automat it. And, as you have
discovered, macros are unavailable for Office 2008. You may be able to make
things easier by protecting the sheet, and unprotecting the entry cells. You
could then use go to special to select the entry cells and clear them all in
one step. I think this is a better approach than trying to learn (or paying
a developer for) an applescript solution.

 

[Laroche J]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a worksheet that I consider to be a "master" worksheet that has detail
data, and a second worksheet that pulls summary data from the "master" .
Every
day, I enter data into the detail "master" worksheet and then save it as a
new
worksheet named "Detail <Current Date>" and I also save the second worksheet
as "Summary <Current Date>".

The next day, I must clear out the detail "master" before I begin entering
new
data. Is there anyway to automate this? My first thought was to record a
macro, but I then discovered that macros are not available.

Vickynh

[/QUOTE]

You should probably revise your workflow. Save the master sheet without
detail data. Every day, open the master, save it immediately with the new
name, then enter your data. You won't have to clear data anymore.

JL
Mac OS X 10.4.11
Office v.X 10.1.9, Office 2008 12.1.latest