Extracting data from another workbook

Closed
Abby - Jun 28, 2010 at 09:33 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 29, 2010 at 03:17 AM
Hello,

I am absolutely new to VBA and I really need some help! I have 2 workbooks, A and B. What I need is to extract info from Workbook A to Workbook B. What I am intending to do is to type in Workbook B the value in the first cell of a row found in Workbook A, and the macro should search for this value in Workbook A and copy the whole row (minus the first cell since I already typed it in to search) into Workbook B. Is this posisble?

Thank you so much!!

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 29, 2010 at 03:17 AM
Could you please upload a zip file containing sample EXCEL files WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
1