+ Reply to Thread
Results 1 to 2 of 2

Copy data from file browsed

  1. #1
    Registered User
    Join Date
    01-16-2014
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    68

    Copy data from file browsed

    I am a newbie and running into problems everyday and need your help. I have a autosheet. I wanted an upload button which when clicked and excel files selected through it and when clicked Copy button will copy the below values from the excel sheet selected to AutoSheet

    column C2 in file selected represents cell c2,e2,g2,i2,k2,m2,o2
    column D2 in file selected represents cell c3,e3,g3,i3,k3,m3,o3
    column E2 in file selected represents cell d3,f3,f3,j3,l3,n3,p3

    Suppose if "BIM Report May 24 - May 30.xlsx" is selected in AutoSheet through upload button and clicked Copy , then in AutoSheet in 2015 worksheet C85,D85,E85 for May 24 will be filled from C2,C3,D3 from BIM Report May 24 - May 30.xlsx sheet and similarly C86,D86,E86 for May 25 sholuld be filled till C91,D91,E91 for May 30 respectively

    AutoSheet and 2 sheets that have to be browsed is uploaded below.

    ABC BIM Report May 24 - May 30.xlsxABC BIM Report May 31 - June 6.xlsxAutoSheet.xlsm

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,372

    Re: Copy data from file browsed

    is there a speficic reasen why the info from May have to go to March ?


    Kind regards
    Leo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Linking Cells from a Browsed For Workbook
    By Dferrier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2015, 09:31 AM
  2. what do I type to specify to import from the folder that I just browsed for?
    By hluk in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-27-2008, 06:46 PM
  3. Excel hyperlinks and browsed pages
    By bgwp in forum Excel General
    Replies: 0
    Last Post: 08-02-2007, 08:27 AM
  4. del Browsed pgs.?
    By boswell6@sbcglobal.net in forum Excel General
    Replies: 2
    Last Post: 03-06-2006, 04:10 PM
  5. [SOLVED] [hyperlink] del 'browsed pgs'?
    By boswell6@sbcglobal.net in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2006, 08:50 AM
  6. Replies: 0
    Last Post: 02-09-2006, 06:10 AM
  7. [SOLVED] Re: Need Help Removing Browsed Pages From Edit Hyperlink Box
    By tra in forum Excel General
    Replies: 0
    Last Post: 10-24-2005, 11:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1