+ Reply to Thread
Results 1 to 8 of 8

automatic data transfer

  1. 01-30-2011, 06:08 PM #1
    Slam21
    Slam21 is offline
    Registered User
    Join Date
    01-30-2011
    Location
    Paris
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    5

    automatic data transfer

    hello,
    I have the following probem:
    There are 10 excel files, each of them contains the same name of the data but different figures (e.x. C5 "number of products"; D6 "221"). All excel files are identical except numbers.

    The aim is to create a data base where all number can be seen together. I organise the order of lines and the figures will transfer from each file one after one"
    (e.x. A1 "number of products"; B1 "221", C1 "14".

    It can be done manually, but there are around 200 fields which are in wrong order.

    Is there a solution for that???
    Reply With QuoteRegister To Reply
  2. 01-30-2011, 07:10 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,621

    Re: automatic data transfer

    "C5 "number of products"; D6 "221" "
    "A1 "number of products"; B1 "221", C1 "14" "

    You could possibly do it with formulae if the workbooks, sheets and ranges are static. For example, if 10 different people each updated one set of data each.

    So: A1 ... =[wb1]Sheet1!$C$5
    ......B1 ... =[wb1]Sheet1!$D$6
    ......C1 ... =[wb1]Sheet1!????
    ..... A2 ... =[wb2]Sheet1!$C$5
    ......B2 ... =[wb2]Sheet1!$D$6
    ......C2 ... =[wb2]Sheet1!????
    and so on.


    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 01-31-2011, 11:27 AM #3
    Slam21
    Slam21 is offline
    Registered User
    Join Date
    01-30-2011
    Location
    Paris
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    5

    Re: automatic data transfer

    Thank you so much for the answer. I believe that is a nice way.
    I was wondering if it could be shorter in the way of seaching the same field in new document and paste data from next field to next field in a new document. So complicated to explain((
    Reply With QuoteRegister To Reply
  4. 01-31-2011, 11:50 AM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,621

    Re: automatic data transfer

    I'm afraid I don't really understand what you mean. It would be helpful if you posted sample workbooks with typical data and indicate what you hope to achieve and where the answer would be.

    The solution above, when extended, links to 10 workbooks ... in fact, it doesn't matter how many provided the naming structure is consistent and the cells are in the same position on the same sheets.

    If you want not to have to type the workbook references, that might be possible with INDIRECT but I'm not 100% sure of that.

    I'm not willing to follow this up at the moment with the limited information available.

    Regards
    Reply With QuoteRegister To Reply
  5. 01-31-2011, 05:20 PM #5
    Slam21
    Slam21 is offline
    Registered User
    Join Date
    01-30-2011
    Location
    Paris
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    5

    Re: automatic data transfer

    Dear TMShucks,
    thank you very much for the answer. I am currently creating template of a final table... then it will be ready for making links to original file. I am about to post it in couple of hours. I can also send it directly to your e-mail.
    Kind regards
    Reply With QuoteRegister To Reply
  6. 01-31-2011, 05:33 PM #6
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,621

    Re: automatic data transfer

    Thank you, but posting to the forum is fine and will give others the opportunity to offer advice and assistance.

    Regards
    Reply With QuoteRegister To Reply
  7. 01-31-2011, 07:34 PM #7
    Slam21
    Slam21 is offline
    Registered User
    Join Date
    01-30-2011
    Location
    Paris
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    5

    Re: automatic data transfer

    I did it already by linking one by one
    Last edited by Slam21; 02-01-2011 at 11:04 PM.
    Reply With QuoteRegister To Reply
  8. 02-01-2011, 02:00 PM #8
    Slam21
    Slam21 is offline
    Registered User
    Join Date
    01-30-2011
    Location
    Paris
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    5

    Re: automatic data transfer

    /////////......
    Last edited by Slam21; 02-01-2011 at 04:28 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1