+ Reply to Thread
Results 1 to 8 of 8

Readout from other sheet, change data accordingly

  1. #1
    Registered User
    Join Date
    11-11-2013
    Location
    hun
    MS-Off Ver
    Excel 2013
    Posts
    76

    Lightbulb Readout from other sheet, change data accordingly

    Hey good ppl of this forum

    UPDATE* I have made some progress, but the worksheet isn't functioning yet, but very close to it, please take a look


    Not_functioning.xlsm


    I'm having some problems making 2 functions in my XLS.
    It is waay far away from my skills, please guys, help this poor dude out

    I've made 2 buttons in the file, everything is clear in the XLS, please check if you feel like helping.

    The easier one, which is still too hard for me
    1, FILTER BUTTON
    -Read sheet: FILTER, column A.
    -If there is match on sheet: - Stock - column B from row 5 to all the way down
    -Then filter rows, to see only lines that match the numbers on FILTER sheet.


    The harder one, which i have no damn idea how to even start with it:
    2, MORPH button
    -Read sheet: UKR, column C. -If there is match on sheet: - Stock - column B from row 5 to all the way down
    -Then copy text
    from: sheet UKR, column A -to: Column D
    from: sheet UKR, column B -to: Column E
    from: sheet UKR, column D -to: Column F
    from: sheet UKR, column E -to: Column G


    Thank you in advance ^^
    Last edited by Viktor86HUN; 12-05-2014 at 03:34 AM.

  2. #2
    Registered User
    Join Date
    11-11-2013
    Location
    hun
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: Readout from other sheet, change data accordingly

    Just bumpin' it up

  3. #3
    Registered User
    Join Date
    11-11-2013
    Location
    hun
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: Readout from other sheet, change data accordingly

    I really need to get this done
    Last edited by Viktor86HUN; 12-04-2014 at 10:10 AM.

  4. #4
    Registered User
    Join Date
    11-11-2013
    Location
    hun
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: Readout from other sheet, change data accordingly

    Take it to the top

  5. #5
    Registered User
    Join Date
    11-11-2013
    Location
    hun
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: Readout from other sheet, change data accordingly

    still starving for information about my project

  6. #6
    Registered User
    Join Date
    11-11-2013
    Location
    hun
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: Readout from other sheet, change data accordingly

    Bringin to the top

  7. #7
    Registered User
    Join Date
    11-11-2013
    Location
    hun
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: Readout from other sheet, change data accordingly

    I just got some progress, it's almost working, but there are still some bugs, can someone check on it please?

  8. #8
    Registered User
    Join Date
    11-11-2013
    Location
    hun
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: Readout from other sheet, change data accordingly

    bump it up

+ 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. Change a Macro to put data on a specific sheet instead of a new sheet
    By qianzhang1988 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2013, 02:03 PM
  2. Pivot Report Filter - Readout/Display selected items in a cell
    By FixandFoxi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2012, 10:19 AM
  3. Replies: 1
    Last Post: 07-22-2011, 12:06 AM
  4. Macro to change Pivot Data to new sheet, where sheet name will change
    By sarails in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2010, 12:10 AM
  5. AutoCalculate Readout Problem
    By Carol M. in forum Excel General
    Replies: 0
    Last Post: 06-12-2006, 04:00 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