vb codes for copying specific range from one excel workbook to other excel workbook

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • shahnawazatiq
    New Member
    • Apr 2010
    • 1

    #1

    vb codes for copying specific range from one excel workbook to other excel workbook

    sirs,
    can anybody give me the VB code for how to copy user specific data from one workbook to other workbook .
    example:i am having database on one workbook say "data1" and one other workbook say "search_she et" which is available to user is having a search box and a command button to search it.user will write some letter in search box and on pressing command button data should be retrieved from data1 workbook
    if it is found else it should give "data not found"
    kindly help me as it is urgently required.
  • yarbrough40
    Contributor
    • Jun 2009
    • 320

    #2
    I helped someone with something similar a few months ago... hope this helps you http://bytes.com/topic/visual-basic/...ne-spreadsheet

    Comment

    Working...