Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vb code - Automatic transfer of data from one sheet to another
Hi. Im doing a school project on spreadsheet, complex formulae, lookup, graphs, macros. I have 3 worksheets - 1 lookup table, 1 booking sheet (an invoice) and 1 for financial summary. for my booking summary i used vb code Selection.ClearContents and everytime i click pertinent data on my invoice is cleared. my real problem is: i wanted those cleared data (in Euro) to be automatically transfered to worksheet no. 3 as follows: column a - invoice no. ; column b- cola; coulmn c - soda, etc. how do i do it with vb? beacse after i get the financial summary i wud do graphs for this. thanks and cud u reply asap coz i need to submit tom. -- herr_bench ------------------------------------------------------------------------ herr_bench's Profile: http://www.excelforum.com/member.php...o&userid=28951 View this thread: http://www.excelforum.com/showthread...hreadid=487528 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vb code - Automatic transfer of data from one sheet to another
See Ron de Bruin's copy to a database site.
Several types of code for various scenarios. http://www.rondebruin.nl/copy1.htm Lotsa luck for tom. Gord Dibben Excel MVP On Wed, 23 Nov 2005 01:10:13 -0600, herr_bench wrote: Hi. Im doing a school project on spreadsheet, complex formulae, lookup, graphs, macros. I have 3 worksheets - 1 lookup table, 1 booking sheet (an invoice) and 1 for financial summary. for my booking summary i used vb code Selection.ClearContents and everytime i click pertinent data on my invoice is cleared. my real problem is: i wanted those cleared data (in Euro) to be automatically transfered to worksheet no. 3 as follows: column a - invoice no. ; column b- cola; coulmn c - soda, etc. how do i do it with vb? beacse after i get the financial summary i wud do graphs for this. thanks and cud u reply asap coz i need to submit tom. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Sort data from 1 work sheet into another | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Merger Two Data Sheet | Excel Discussion (Misc queries) | |||
Transfer data from sheet to sheet | Excel Discussion (Misc queries) |