News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • Import data based on specific word in above cell.

    Posted on shazzad.arla Comment on the AskWoody Lounge

    Home Forums AskWoody support Productivity software by function MS Excel and spreadsheet help Import data based on specific word in above cell.

    Topic Resolution: Resolved
    Viewing 4 reply threads
    • Author
      Posts
      • #2087416 Reply
        shazzad.arla
        AskWoody Lounger

        Hi All,

        I have a file of raw data of my 3 people with a switch of each. When i click on the switch individual sheet for each is created. Long ago, a good guy named @Zeddy helped me to build the macro and it was working great. Now I am trying to bring a bit change where sheets will remain by default in the file. And when the button will be clicked, data will be imported to the sheet of specific name if the above cell of the data carry the name(KPL, BPL,HPL). Could you please help me to edit the macro so that the operation can be run ??

        Please have a look at the link where I have shared my file and feel free to knock for any info.

        Click here for the file

        Regards

        Shazzad

      • #2088159 Reply
        zeddy
        AskWoody_MVP

        Hi Shazzad

        Is it because the previous process took too long when the sheets are created each and every time for the [KPL], [HPL] and [BPL] tabs????

        If you prefer, this could be speeded-up by keeping the tabs as you suggest, and then only processing the ‘date-columns’ on the [Data] sheet which do not already exist on those tabs.

        In which case, we could replace the three buttons on the [Data] sheet, and have just one that says [Update All Sheets], which would ignore the date-columns that have already been added to each of the sheets.

        If you wanted to re-process all dates on the [Data] sheet, you could then just use the previous version.

        NOTE: I haven’t included full error-checking in the attached v2a file (for example if any of the sheets are completely empty etc etc etc)

        For testing, save the attached zip file to a folder of your choice, then extract the macro-file within the zip file and load into Excel with macros-enabled etc etc etc.

        in this version v2a..

        sheet [KPL] has only 1-column, for Jan-11

        sheet [BPL] has 2-columns, up to Jan-12

        sheet [HPL] has 3-columns, up to Jan-13

        The sheet [Data] has 4-columns, up to Jan-14

        After clicking the [Update All Sheets] button on the [Data] sheet, all tabs will be updated to Jan-14 with their respective data.

        Hope this helps you.

        I am off to NYC tomorrow morning, back next week.

        best regards

        zeddy

        Shazzad-data-zeddy-v2a

         

        Attachments:
        1 user thanked author for this post.
      • #2124440 Reply
        shazzad.arla
        AskWoody Lounger

        @Zeddy,

        Thanks for your magical solution. I was expecting something like this but it would be better if all the data be updated as soon as I click the button, not only the lastet date that is not updated, since i have to update sometimes the back data as well. Is it possible to do??

        And sorry for late response to you as I was going through some hard times in my personal life.Accept my apology.

         

        Regards

        Shazzad.

        • #2125237 Reply
          zeddy
          AskWoody_MVP

          Hi Shazzad

          In the attached zip file I have included an updated version v3a file which now has two buttons on the [Data] sheet.

          This version assumes that the sheet tabs have already been created, and will remain in the file.
          You can now choose to [Re-build All Sheets] or [Update with Latest Data].

          If you wanted to re-process the sheet tabs with all dates on the [Data] sheet, you click the [Re-build All Sheets] button. Any existing data on the sheet tabs will be replaced.

          If you want to just process the new ‘date-columns’ on the [Data] sheet which do not already exist on the tabs then click the [Update with Latest Data] button.

          I have added a timer-message to indicate how long the process takes.
          In my tests with the attached file, it takes less time than hearing the horn from a New York taxi when the traffic light turns green (one of the shortest time intervals known to mankind).

          If you have any questions, just ask. We are here to help.
          ..and I hope you overcome your recent challenges.

          zeddy

          Shazzad-data-zeddy-v3a

          Attachments:
          1 user thanked author for this post.
      • #2171394 Reply
        shazzad.arla
        AskWoody Lounger

        Heeyy Zeddy,

        I don’t know what went wrong when I replied you to your immediate reply. I am sorry for having you the reply late. You are just no less than an awesome solver if my problem. And I don’t know the exact word to convey my gratitude towards your effort. But a bigggg thanks to you 🙂

        And I am doing good overcoming my challenges.

         

        Best Regards

        Shazzad

      • #2172436 Reply
        zeddy
        AskWoody_MVP

        Hi Shazzad

        It is always good to hear from you.

        We appreciate your thanks.

        We like helping when we can.

        That is what this Lounge is for.

        Keep doing good things.

        zeddy

        1 user thanked author for this post.
    Viewing 4 reply threads

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: Import data based on specific word in above cell.

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.