vb code - Automatic transfer of data from one sheet to another

  • Thread starter Thread starter herr_bench
  • Start date Start date
H

herr_bench

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transferring CERTAIN Data from one worksheet to another 1
Copy last cell with data in column E on one sheet to cell on anoth 7
Transferring data from one worksheet or workbook to another 5
How do I transfer data from 1 sheet to another? 2
Automatically add a column to summary sheet if another worksheet i 2
data to summary sheet for a dummy 0
Copy Data from 1 Sheet to Another 3
Losing rows that reference data from another worsheet 1

Back
Top