+ Reply to Thread
Results 1 to 6 of 6

Help in importing certain data

  1. #1
    Registered User
    Join Date
    02-09-2010
    Location
    Serbia, Belgrade
    MS-Off Ver
    Excel 2003
    Posts
    3

    Help in importing certain data

    Hi guys/girls, new here. I really need your help.

    I know a lot of stuff in Excel, but have never used macros, excep SUM function.
    So i need your help on this:

    Soon, a mobile provider, on whom we shall make contract with, will send us a list of mobile phones, and how much users used them in terms of money. And it will be in excel format.

    Examp:
    ......................A...................................B
    1 .......0134367890(cell number) 134(money)

    I wish to create an excel file, which will contain names of users and their mobile numbers, and all I want to do is, that this excel file, which I will create, can read external excel file(provided by mobile operator) where my excel file reads pricing according to mobile number provided, and puts them in certain places, where in the end it will calculate pricing for every user.

    Thnx.
    Last edited by projectnemesis; 02-15-2010 at 07:07 PM.

  2. #2
    Registered User
    Join Date
    02-09-2010
    Location
    Serbia, Belgrade
    MS-Off Ver
    Excel 2003
    Posts
    3

    re: importing certain data

    Bumpity Bump

  3. #3
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    re: importing certain data

    It is difficult to help you with out the actual information about your destination sheet

  4. #4
    Registered User
    Join Date
    02-09-2010
    Location
    Serbia, Belgrade
    MS-Off Ver
    Excel 2003
    Posts
    3

    re: importing certain data

    Ok, I will rephrase myself, in hope to be more accurate. :D

    Source excel file, from mobile provider, consists of mobile numbers and prices (how much user of mobile phone/s have spent).
    Column A(phone numbers), column B(pricing)

    Destination file(created by me) consists of user names/surnames, their mobile numbers, and pricing.
    Column A(names/surnames sorted alphabetically), column B(phone numbers), column C(pricing), column D(sum, if user has more phone numbers than one)

    Now, what I want is something like this:

    Destination file:

    Column A1,2,3...... has name/surname, column B1,2,3..... has phone numbers, column C1,2,3 is empty(this is where pricing will be putted from source file).
    Now, I want phone numbers from destination file to query column A from source file. for example, if mobile phone number, on destination file, is on column B1 and matching/queried number on source file is on column A134, column B1(destination) will also read pricing on column B134 and write it on column C1 on destination file.

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    re: importing certain data

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    TITLE EDITED
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  6. #6
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: importing certain data

    I assume when you say Column A134, Column B134, you mean Row 134

    The trouble I am having with your examples are that there are a lot of unanswered questions. Like

    Why do you need a macro to do this? You can use the =vlookup( ) function to bring the information in from your source sheet and then copy/paste the =vlookup( ) function with the actual data. Is that what you want?

    Maybe the source file changes every month? - I have no idea.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1