how to transfar data from work book to another one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have two separated worksheets and I need to transfer data from worksheet 1
to worksheet 2 if condition is done. Can any body help me plezzzzzzzzz
Thanks!!
 
More information on what is required: for example, what is(are) the
condition(s)? And what data is in what columns etc
 
In worksheet 1 A1 the contracting date of apartment, B1 payment date, C1
payment status (yes or no). If the contractor does not pay the contracting
money as per payment date, his data will be transferred to worksheet 2. And
if the status of the payment in worksheet 2 being yes, the contractor data
will return again to worksheet 1
Hop this is clear
And thank you a lot for your cooperation
 
This seems (needlessly) complex if you are transferring (deleting/adding)
data between w/sheets. Why not have a status on workshhet1 to indicate
payment overdue (not yet paid) and/or late (paid but not by due date)?
 
I think you need to give this a liitle more consideration: for example, is
Payment Date (B1) the "payment due date" or "actual payment date"; you may
need two fields - one for due and one for actual. and there no field the
monetary amount.

Also think about what analysis you might want to do as this will determine
the data you need.
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Move or Copy Stopped Working? 0
transfare contacts to vista from xp 1
transfer data from worksheet to another 1
Pulling data from one cell to another 3
Excel VBA 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to use multiple command button to copy user form data to multiple worksheet 0

Back
Top