ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Template & Database Question (https://www.excelbanter.com/excel-worksheet-functions/93291-template-database-question.html)

SteveT

Template & Database Question
 
I am very new with Macros but have grande expectations.

My workbook contains Template sheet that when key cells updated, summary
information auto populates lower section of Template.
I DESIRE & ENVISION
having a Macro button, within the template, that when pushed
1) prints template
2) Updates a Database 2nd wksheet within wkbook.
3) Auto saves information on the next blank available row
4) Deletes template data (returns template to blank condition)

I know this is multifaceted question but have faith possible.

Any assistance wud be most appreciated.

StevenT



There are apx 10 cells that I want a the database sheet within same w.b.


Ron de Bruin

Template & Database Question
 
See your other thread

--
Regards Ron De Bruin
http://www.rondebruin.nl



"SteveT" wrote in message ...
I am very new with Macros but have grande expectations.

My workbook contains Template sheet that when key cells updated, summary
information auto populates lower section of Template.
I DESIRE & ENVISION
having a Macro button, within the template, that when pushed
1) prints template
2) Updates a Database 2nd wksheet within wkbook.
3) Auto saves information on the next blank available row
4) Deletes template data (returns template to blank condition)

I know this is multifaceted question but have faith possible.

Any assistance wud be most appreciated.

StevenT



There are apx 10 cells that I want a the database sheet within same w.b.




SteveT

Template & Database Question
 
I posted same question a week ago with no reply...
thought would try couple differents ways to get a response.

thanks

"Ron de Bruin" wrote:

See your other thread

--
Regards Ron De Bruin
http://www.rondebruin.nl



"SteveT" wrote in message ...
I am very new with Macros but have grande expectations.

My workbook contains Template sheet that when key cells updated, summary
information auto populates lower section of Template.
I DESIRE & ENVISION
having a Macro button, within the template, that when pushed
1) prints template
2) Updates a Database 2nd wksheet within wkbook.
3) Auto saves information on the next blank available row
4) Deletes template data (returns template to blank condition)

I know this is multifaceted question but have faith possible.

Any assistance wud be most appreciated.

StevenT



There are apx 10 cells that I want a the database sheet within same w.b.






All times are GMT +1. The time now is 06:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com