Filling info on one sheet also places it in a data base

February 21, 2013 at 18:28:59
Specs: Windows 7 and xp
Hi Everyone can information filled in on a Excel 2007 spreadsheet such as name, address, telephone email etc. be transferred when that sheet is closed to another sheet with a data base so that the information can be kept and used to send out invoices.
Thanks
Bazza

See More: Filling info on one sheet also places it in a data base

Report •

#1
February 21, 2013 at 19:18:46
While I'm not sure what you mean by a "sheet with a database" the answer to your question is "yes", data can be moved from one sheet to another when the workbook is closed or a sheet is deactivated.

You can use a macro known as the BeforeClose event. The macro is placed in the ThisWorkbook module and runs just before the workbook actually closes.

You can also used the SheetDeactivate event when which runs when a sheet is deactivated...in other words when the user switches to another sheet.

We would need to know exactly what you want the code to do before we could offer any more help.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
February 22, 2013 at 01:30:00
DerbyDad03 Thanks for quick reply. You may remember I am helping in a small plumbing business (I asked about data validation vlookup etc) On this spreadsheet I have a place where the clients information is filled in Name, Address, Telephone etc. What I want to do is for this information as well as the material and Gas heater model we supplied to go on to another spreadsheet. This would be may data sheet with the information going across the sheet from left to right. This information is sent either as it is typed in or on saving and closing. I want to use this data sheet to keep track on client information and what we supplied for a later date as well as using it to contact these clients in a mail out with special deals etc. I hope I explained myself.
Did you understand my explanation about the problem I found with 2007 and 2010.
Thanks again Bazza

Report •

#3
February 22, 2013 at 04:23:22
As for the 2007/2010, I have not spent anytime on your explanation. I only have 2003 and 2010 available so I can't test anything anyway.

A macro could easily be written to move data to another sheet, but we unless you know how to code in VBA, we would need the exact location of the data to be moved and some information about where it will be moved to.

If you want to try to modify some generic code for copying data - which is a great way to learn VBA - let us know. If you want a "finished product" then you need to be very specific and detailed with the information you supply.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
March 11, 2013 at 02:12:33
Hi DerbyDad03 sorry I haven't got back to you soon been away on holiday. I live in Australia and we have been having some great weather. Picked a good couple of weeks. I have an Excel book set up to attach to this reply but I dont know how to attach it can you help?

Report •

#5
March 11, 2013 at 11:05:10
You can not attach a workbook to a post in this forum. You can post it on the web and provide a link in your post.

One of my concerns would be related to your (or someone within your company) ability to maintain a workbook that is dependent upon macros. One of the dangers of getting free help in a forum such as this is that the solution works for a while, but when your business changes, or parts are added, or a form needs to be changed, there isn't anyone on staff with the skill set to "upgrade" the code.

It wouldn't be a good business model to have to post questions in a help forum every time a change needs to be made.

Do you or a coworker have any VBA coding experience or experience with other types of programming that could be adpated to VBA? If not, then you might find it more advantageous to invest in a commercially available invoicing/inventory/contact management software package.

I'm willing to help, but neither I or nor anyone else out here on the web can commit to being available for long term maintenance.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question