ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Need help with macros and formatting templates in Excel (https://www.excelbanter.com/excel-worksheet-functions/122771-need-help-macros-formatting-templates-excel.html)

SuzyQ

Need help with macros and formatting templates in Excel
 
Thank you to John Bundy for your answer. PROBLEM...Is you answer a macro
that I would type into each line where I want the entered data to be
automatically transferred to the second page???? Afraid I don't know
anything about macros anymore. Many years ago, I learned macros using Lotus
123, but that was eons ago and have forgotten anything I learned...Do you
have the time and/or patience and/or inclination to lead me by the hand...so
I can relearn what I need to do??? Is there a Workbood for EXcel that I can
buy to use as a reference to help me with my occasional problems???
AGAIN...thank you for your response.
SuzyQ

John Bundy

Need help with macros and formatting templates in Excel
 
No, it is a "macro" for lack of better word that runs through VB, you can
assign this to a button on your page, create a form that allows you to choose
multiple pages, or in your workbooks etc. You can also do it easily manually.
As far as a book to help you, there are many but between Google and this
newsgroup I've never been lost, I can at least get a good direction. I mostly
post here to keep my skills up in case I ever do get a job doing this full
time, but I enjoy helping others the most, I have gotten so much from the
regulars here I'm trying to pay a little back. As far as help I can do my
best, you are free to e-mail me at (take out the x's) and
I will do what I can. As far as time I work weekend nights so Mon-Thurs I am
up and about 18 hours a day.
Just send me what you need and we can go over it.

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"SuzyQ" wrote:

Thank you to John Bundy for your answer. PROBLEM...Is you answer a macro
that I would type into each line where I want the entered data to be
automatically transferred to the second page???? Afraid I don't know
anything about macros anymore. Many years ago, I learned macros using Lotus
123, but that was eons ago and have forgotten anything I learned...Do you
have the time and/or patience and/or inclination to lead me by the hand...so
I can relearn what I need to do??? Is there a Workbood for EXcel that I can
buy to use as a reference to help me with my occasional problems???
AGAIN...thank you for your response.
SuzyQ



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

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