Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros VBA and Converting Form to Database
I have a workbook that logs our inbound calls. In this workbook the first
sheet (Call Record) is like a form where the headings are in Column A and you are inputting information (heading such as DATE, Client Manager, Contact Name, Firm Name, etc) into Column B. I know it's possible to put a button at the end of this form that will not only print out the form, but transfer the information into the second sheet (Inbounds) where the information is put in rows (Header row contains the information from Column A on the first sheet). I've linked worksheets and workbooks together before and done formulas and functions and although I know this can be done I don't have the foggiest of how to go about doing it. Any help? TIA!!!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros VBA and Converting Form to Database
Thanks so much for your reply, Ron. Let me just reiterate that I have
absolutely no knowledge of VBA - so...do I just copy and paste what you have into my Visual Basic editor? Sorry to ask for further explanation but I am a complete "dummy" when it comes to this and have no idea what I'm doing. Thanks again! "Ron de Bruin" wrote: Hi Lori Try http://www.rondebruin.nl/copy1.htm Read this tip Tip: Use a row below your data (if the range have separate areas) with links to cells you want (=C3 in A50, =G15 in B50, €¦..). You can hide this row if you want and copy a range like A50:Z50 for example with one of the values copy examples. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "IMS Lori" <IMS wrote in message ... I have a workbook that logs our inbound calls. In this workbook the first sheet (Call Record) is like a form where the headings are in Column A and you are inputting information (heading such as DATE, Client Manager, Contact Name, Firm Name, etc) into Column B. I know it's possible to put a button at the end of this form that will not only print out the form, but transfer the information into the second sheet (Inbounds) where the information is put in rows (Header row contains the information from Column A on the first sheet). I've linked worksheets and workbooks together before and done formulas and functions and although I know this can be done I don't have the foggiest of how to go about doing it. Any help? TIA!!!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros VBA and Converting Form to Database
Hi Lori
Send me a private mail and I send you a small example workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "IMS Lori" wrote in message ... Thanks so much for your reply, Ron. Let me just reiterate that I have absolutely no knowledge of VBA - so...do I just copy and paste what you have into my Visual Basic editor? Sorry to ask for further explanation but I am a complete "dummy" when it comes to this and have no idea what I'm doing. Thanks again! "Ron de Bruin" wrote: Hi Lori Try http://www.rondebruin.nl/copy1.htm Read this tip Tip: Use a row below your data (if the range have separate areas) with links to cells you want (=C3 in A50, =G15 in B50, €¦..). You can hide this row if you want and copy a range like A50:Z50 for example with one of the values copy examples. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "IMS Lori" <IMS wrote in message ... I have a workbook that logs our inbound calls. In this workbook the first sheet (Call Record) is like a form where the headings are in Column A and you are inputting information (heading such as DATE, Client Manager, Contact Name, Firm Name, etc) into Column B. I know it's possible to put a button at the end of this form that will not only print out the form, but transfer the information into the second sheet (Inbounds) where the information is put in rows (Header row contains the information from Column A on the first sheet). I've linked worksheets and workbooks together before and done formulas and functions and although I know this can be done I don't have the foggiest of how to go about doing it. Any help? TIA!!!!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros VBA and Converting Form to Database
Since I haven't received a response, just wondering if you received my
offline email? Thanks! "Ron de Bruin" wrote: Hi Lori Send me a private mail and I send you a small example workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "IMS Lori" wrote in message ... Thanks so much for your reply, Ron. Let me just reiterate that I have absolutely no knowledge of VBA - so...do I just copy and paste what you have into my Visual Basic editor? Sorry to ask for further explanation but I am a complete "dummy" when it comes to this and have no idea what I'm doing. Thanks again! "Ron de Bruin" wrote: Hi Lori Try http://www.rondebruin.nl/copy1.htm Read this tip Tip: Use a row below your data (if the range have separate areas) with links to cells you want (=C3 in A50, =G15 in B50, €¦..). You can hide this row if you want and copy a range like A50:Z50 for example with one of the values copy examples. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "IMS Lori" <IMS wrote in message ... I have a workbook that logs our inbound calls. In this workbook the first sheet (Call Record) is like a form where the headings are in Column A and you are inputting information (heading such as DATE, Client Manager, Contact Name, Firm Name, etc) into Column B. I know it's possible to put a button at the end of this form that will not only print out the form, but transfer the information into the second sheet (Inbounds) where the information is put in rows (Header row contains the information from Column A on the first sheet). I've linked worksheets and workbooks together before and done formulas and functions and although I know this can be done I don't have the foggiest of how to go about doing it. Any help? TIA!!!!! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros VBA and Converting Form to Database
No, the example file is on my desktop waiting for you
Try it again -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "IMS Lori" wrote in message ... Since I haven't received a response, just wondering if you received my offline email? Thanks! "Ron de Bruin" wrote: Hi Lori Send me a private mail and I send you a small example workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "IMS Lori" wrote in message ... Thanks so much for your reply, Ron. Let me just reiterate that I have absolutely no knowledge of VBA - so...do I just copy and paste what you have into my Visual Basic editor? Sorry to ask for further explanation but I am a complete "dummy" when it comes to this and have no idea what I'm doing. Thanks again! "Ron de Bruin" wrote: Hi Lori Try http://www.rondebruin.nl/copy1.htm Read this tip Tip: Use a row below your data (if the range have separate areas) with links to cells you want (=C3 in A50, =G15 in B50, €¦..). You can hide this row if you want and copy a range like A50:Z50 for example with one of the values copy examples. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "IMS Lori" <IMS wrote in message ... I have a workbook that logs our inbound calls. In this workbook the first sheet (Call Record) is like a form where the headings are in Column A and you are inputting information (heading such as DATE, Client Manager, Contact Name, Firm Name, etc) into Column B. I know it's possible to put a button at the end of this form that will not only print out the form, but transfer the information into the second sheet (Inbounds) where the information is put in rows (Header row contains the information from Column A on the first sheet). I've linked worksheets and workbooks together before and done formulas and functions and although I know this can be done I don't have the foggiest of how to go about doing it. Any help? TIA!!!!! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros VBA and Converting Form to Database
My E-mail address is on this page
http://www.rondebruin.nl/ -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... No, the example file is on my desktop waiting for you Try it again -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "IMS Lori" wrote in message ... Since I haven't received a response, just wondering if you received my offline email? Thanks! "Ron de Bruin" wrote: Hi Lori Send me a private mail and I send you a small example workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "IMS Lori" wrote in message ... Thanks so much for your reply, Ron. Let me just reiterate that I have absolutely no knowledge of VBA - so...do I just copy and paste what you have into my Visual Basic editor? Sorry to ask for further explanation but I am a complete "dummy" when it comes to this and have no idea what I'm doing. Thanks again! "Ron de Bruin" wrote: Hi Lori Try http://www.rondebruin.nl/copy1.htm Read this tip Tip: Use a row below your data (if the range have separate areas) with links to cells you want (=C3 in A50, =G15 in B50, €¦..). You can hide this row if you want and copy a range like A50:Z50 for example with one of the values copy examples. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "IMS Lori" <IMS wrote in message ... I have a workbook that logs our inbound calls. In this workbook the first sheet (Call Record) is like a form where the headings are in Column A and you are inputting information (heading such as DATE, Client Manager, Contact Name, Firm Name, etc) into Column B. I know it's possible to put a button at the end of this form that will not only print out the form, but transfer the information into the second sheet (Inbounds) where the information is put in rows (Header row contains the information from Column A on the first sheet). I've linked worksheets and workbooks together before and done formulas and functions and although I know this can be done I don't have the foggiest of how to go about doing it. Any help? TIA!!!!! |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros VBA and Converting Form to Database
I re-sent the email. Maybe it got stuck in your spam filter or something...
Thanks again!!!!! "Ron de Bruin" wrote: My E-mail address is on this page http://www.rondebruin.nl/ -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... No, the example file is on my desktop waiting for you Try it again -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "IMS Lori" wrote in message ... Since I haven't received a response, just wondering if you received my offline email? Thanks! "Ron de Bruin" wrote: Hi Lori Send me a private mail and I send you a small example workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "IMS Lori" wrote in message ... Thanks so much for your reply, Ron. Let me just reiterate that I have absolutely no knowledge of VBA - so...do I just copy and paste what you have into my Visual Basic editor? Sorry to ask for further explanation but I am a complete "dummy" when it comes to this and have no idea what I'm doing. Thanks again! "Ron de Bruin" wrote: Hi Lori Try http://www.rondebruin.nl/copy1.htm Read this tip Tip: Use a row below your data (if the range have separate areas) with links to cells you want (=C3 in A50, =G15 in B50, €¦..). You can hide this row if you want and copy a range like A50:Z50 for example with one of the values copy examples. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "IMS Lori" <IMS wrote in message ... I have a workbook that logs our inbound calls. In this workbook the first sheet (Call Record) is like a form where the headings are in Column A and you are inputting information (heading such as DATE, Client Manager, Contact Name, Firm Name, etc) into Column B. I know it's possible to put a button at the end of this form that will not only print out the form, but transfer the information into the second sheet (Inbounds) where the information is put in rows (Header row contains the information from Column A on the first sheet). I've linked worksheets and workbooks together before and done formulas and functions and although I know this can be done I don't have the foggiest of how to go about doing it. Any help? TIA!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|