• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA for copy paste from sheet1 to sheet2 based data in Sheet2

M

Mageshwaran

New Member
Dear friends,
I have one workbook in that sheet 1 has thousands of customer data.
I want macros to copy a particular customers data from sheet 1 paste to sheet2 in a particular cell.
For example if I enter a customer account number in A1 cell of sheet2
vba has to match the account no with sheet1 table and copy the respective name and address fields and past in B2 of sheet 2.

Kindly help me.This is very urgent.
Thanks in advance.
 

Attachments

Thanks a lot sir.
Small modification i need.
Name should paste seperately in B1 of sheet2.
Rest of fields has to paste in B2 of sheet2 .Each column has to be sepearateled with comma(,).
If u try it for me i will be grateful friend.
Thanks in advance
 
Dear friend,

I have attached actual file.

In that only I am going to operate.

To reduce file size I have listed only few no of account for sample. There will be 30,000 accounts.

If I feed account no in H6 of Sheet2(F120A),

CIF No in H7 of F120A
Name will be displayed in D15 of F120A
Address in D16 of F120A
Contact no in D19 of F120A

Like that if I feed account in H7 of Sheet3(F120B)
CIF No in H8 of F120A
Name will be displayed in D16 of F120A
Address in D17 of F120A
Contact no in D20 of F120A
Kindly help me
 

Attachments

Dear friend,

I have attached actual file.

In that only I am going to operate.

To reduce file size I have listed only few no of account for sample. There will be 30,000 accounts.

If I feed account no in H6 of Sheet2(F120A),

CIF No in H7 of F120A
Name will be displayed in D15 of F120A
Address in D16 of F120A
Contact no in D19 of F120A
Like that if I feed account in H7 of Sheet3(F120B)
CIF No in H8 of F120B
Name will be displayed in D16 of F120B
Address in D17 of F120B
Contact no in D20 of F120B
Kindly help me
 
Sorry dont mistaken me.
I didnt find any QAT.
As previous,kindly provide Form cintrol button.That itself enough frnd.
Dont think that i m disturbing
 
Finally i found the QAT.
I error is there.
macros extracting details the if input given in only A1 of both sheets instead of H6 of 120A,H7 of 120B......
 
Finally i found the QAT.
But one error is there.
i.e. macros extracting details the if input given in only A1 of both sheets instead of H6 of 120A,H7 of 120B......[/quote]

Finally i found the QAT.
I error is there.
macros extracting details the if input given in only A1 of both sheets instead of H6 of 120A,H7 of 120B......
 
You must log in or register to reply here.
Back
Top