Macro for extracting information from one worksheet to other:
I have attached two sheets book1,book2
Book1: Having the source information
Book2: Extract the value from the book1 & put in the proper place.
Book 2 - Red marked column to be created & filled automatically [L Value]
By clicking the command button from book1,data to be filled automatically populated in book2.
Please guide me for the same
Last edited by sugavanam; 08-08-2011 at 03:01 AM. Reason: Attaching File
I have attached the file now...
Hello sugavanam,
Welcome to the Forum!
I have a few questions about your workbooks.
- Will workbook 1 always have 10 columns?
- Will the maximum number of items be 500?
- Will the table in workbook 2 already exist as shown?
- Will each item be unique?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Will workbook 1 always have 10 columns? No,will get change
Will the maximum number of items be 500? yes
Will the table in workbook 2 already exist as shown? Only Item information & column to
be created based on book1
Will each item be unique? yes
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks