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 shee
(an invoice) and 1 for financial summary. for my booking summary i use
vb code Selection.ClearContents and everytime i click pertinent data o
my invoice is cleared. my real problem is: i wanted those cleared dat
(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
do it with vb? beacse after i get the financial summary i wud do graph
for this. thanks and cud u reply asap coz i need to submit tom

--
herr_benc
-----------------------------------------------------------------------
herr_bench's Profile: http://www.excelforum.com/member.php...fo&userid=2895
View this thread: http://www.excelforum.com/showthread.php?threadid=48756