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.

    This topic contains 3 replies, has 2 voices, and was last updated by  zeddy 1 week, 6 days ago.

    • Author
    • #2087416 Reply

      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



    • #2088159 Reply


      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




      1 user thanked author for this post.
    • #2124440 Reply

      AskWoody Lounger


      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.




      • #2125237 Reply


        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.



        1 user thanked author for this post.

    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.