Closed Thread
Results 1 to 9 of 9

[Help] I'm still new in this excel program, and got a problem to call a data in 1 workbook

  1. #1
    Registered User
    Join Date
    02-16-2017
    Location
    Indonesia
    MS-Off Ver
    2013
    Posts
    4

    Question [Help] I'm still new in this excel program, and got a problem to call a data in 1 workbook

    i've been wandering in youtube also several excel tips site, yet i don't find any formulas that suit my final outcome..
    So , i got so many raw data in one sheet ,
    what i want to do is to arrange it nicely so it could be easily read and printed in another new sheet. still same workbook

    i make 3 sheet in this workbook
    first sheet is Raw Data sheet = where all the messy data live in this sheet
    2nd one is What i want sheet = where there is a several text box and arrow to show all the master excel in this forum what i really want to do
    3rd is final outcome sheet = it show how will it be done , when the formula is being put in.

    will it be done using only formulas , or i must learn a macro / VBA to do it..

    maybe i asking to much , but if i get any help i will really appreciate it ,
    Thank you so much..
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: [Help] I'm still new in this excel program, and got a problem to call a data in 1 work

    I think you should read HERE first

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,031

    Re: [Help] I'm still new in this excel program, and got a problem to call a data in 1 work

    Which particular rule do you think that the OP needs to look at more closely, Sandy? Are you referring to the volume of work expected? If so, then I would be inclined to agree with you.

    Rakuen - you are asking for a complete solution, not just a bit of help. What have you tried yourself that hasn't worked? I don't see any attempts at complex formulae in your workbook. If it really is the entire solution you need, then you ought to consider posting in the Commercial Services section and offering a payment.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  4. #4
    Registered User
    Join Date
    02-16-2017
    Location
    Indonesia
    MS-Off Ver
    2013
    Posts
    4

    Re: [Help] I'm still new in this excel program, and got a problem to call a data in 1 work

    Quote Originally Posted by sandy666 View Post
    I think you should read HERE first
    Sorry sir , i will edit my post..
    thanks

  5. #5
    Registered User
    Join Date
    02-16-2017
    Location
    Indonesia
    MS-Off Ver
    2013
    Posts
    4

    Re: [Help] I'm still new in this excel program, and got a problem to call a data in 1 work

    Quote Originally Posted by AliGW View Post
    Which particular rule do you think that the OP needs to look at more closely, Sandy? Are you referring to the volume of work expected? If so, then I would be inclined to agree with you.

    Rakuen - you are asking for a complete solution, not just a bit of help. What have you tried yourself that hasn't worked? I don't see any attempts at complex formulae in your workbook. If it really is the entire solution you need, then you ought to consider posting in the Commercial Services section and offering a payment.
    i've made purchase with paypal , but i got nowhere to see my purchased $$
    i try in there, thanks for your reply

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,031

    Re: [Help] I'm still new in this excel program, and got a problem to call a data in 1 work

    I do not see a post by you there. Here's how it works: http://www.excelforum.com/showthread.php?t=953690

  7. #7
    Registered User
    Join Date
    02-16-2017
    Location
    Indonesia
    MS-Off Ver
    2013
    Posts
    4

    Re: [Help] I'm still new in this excel program, and got a problem to call a data in 1 work

    Quote Originally Posted by AliGW View Post
    I do not see a post by you there. Here's how it works: http://www.excelforum.com/showthread.php?t=953690
    Done , so will this thread being closed by moderator ?
    or should i close it by myself?
    thanks again sis..^^
    best regards

  8. #8
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,279

    Re: [Help] I'm still new in this excel program, and got a problem to call a data in 1 work

    my suggestion : Firstly remove all merge cell. It is not good pratics.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,031

    Re: [Help] I'm still new in this excel program, and got a problem to call a data in 1 work

    Thread closed. The OP has opted to post in the Commercial Services section.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. A problem when running program code residing in another workbook
    By eMKaa in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-17-2016, 06:41 AM
  2. Program Flow Stops and Will not Return After Call
    By SDruley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-03-2010, 08:11 PM
  3. call another program
    By dHouge in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2008, 04:40 AM
  4. Call external program in Excel Macro
    By Ivan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2006, 07:00 AM
  5. [SOLVED] Date problem in Excel when data is generated from external program
    By R Sathyamurthy in forum Excel General
    Replies: 3
    Last Post: 10-24-2005, 07:05 PM
  6. Unable to call external program/dll
    By pipo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2005, 03:11 AM
  7. Call Schedule Program in Excel
    By raddoc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2005, 07:35 AM

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