Import data based on specific word in above cell.

Topic

New Reply

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

Reply | Quote

Replies

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

 

1 user thanked author for this post.

shazzad.arla

Reply | Quote

@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.

Reply | Quote

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

1 user thanked author for this post.

shazzad.arla

Reply | Quote

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

Reply | Quote