Transforming a worksheet's functionality?
 

Hello Everybody. How is your Friday?

Okay, is it possible, using a recordable Macro or VBA, to change a
worksheet's functionality?

For instance, I have a workbook with one Formatted Data Entry sheet and one
No-Format Archive sheet that stores all the raw data (no formulas) for future
retrieve. Is it possible to change the Data Entry sheet from user input mode
to archive retrieval mode?

In data entry mode, Column D and G are blank to allow for user input. In
archive mode, Column D and G would need formulas which grabbed data from the
corresponding cells on the archive sheet.

The solution should also be able to lock/unlock those cells accordingly.

Can this be done?

Thanks for your time and help.

Arlen

I'm not sure, but how about a slight change.

On the archival sheet (values, not formulas), you put a button that runs a
macro.

That macro takes the values out of the activerow (user selects the row before
hitting the button), then populates the Input sheet.

The macro would be used instead of formulas. So instead of the user typing
them, the macro would "type" them.



Arlen wrote:

Hello Everybody. How is your Friday?

Okay, is it possible, using a recordable Macro or VBA, to change a
worksheet's functionality?

For instance, I have a workbook with one Formatted Data Entry sheet and one
No-Format Archive sheet that stores all the raw data (no formulas) for future
retrieve. Is it possible to change the Data Entry sheet from user input mode
to archive retrieval mode?

In data entry mode, Column D and G are blank to allow for user input. In
archive mode, Column D and G would need formulas which grabbed data from the
corresponding cells on the archive sheet.

The solution should also be able to lock/unlock those cells accordingly.

Can this be done?

Thanks for your time and help.

Arlen

--

Dave Peterson