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

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.