Auto populate data

[cyee]

Hi Pros,

I have a workbook. It contains individual data in individual sheets.
Would like to check if there is any formula or macro to auto populate data in individual sheet into a main sheet called "expired bills"?

I attached a sample here for better understanding.

Really appreciate your help here.
TIA.

[cyee]

I found this code from on the the post. It is post by @Marc L.
I have change the name of the sheet from "Combined" to "EXPIRED BILLS"
May i know how can i modify to copy sheet C, D, E and so on?

Please Login or Register  to view this content.

[nankw83]

Hi cyee,

Try below code ...

Please Login or Register  to view this content.

[vcoolio]

Hello Cyee,

I assume that you just want all data from all source sheets transferred to the destination sheet. If so, this may help:-

Please Login or Register  to view this content.

I hope that this helps.

Cheerio,
vcoolio.

[cyee]

Hi cyee,

Try below code ...

Please Login or Register  to view this content.

Hi nankw83,
Your code work amazing on my sample files.
However, it doesnt work well on my actual file.

Sorry forgot to inform you guys that, the data on Tab A,B,C,D and so on are paste link from another workbook.
So it contain formula on tab a,b,c, & etc.

Possible to modify?

[nankw83]

How about now ?

Please Login or Register  to view this content.

[cyee]

Nope. It dont work. it only copy 1st sheet.
May i know it is because of the name on the sheet? Actual I name it as person name.

[nankw83]

I didn't get it ... Did you get any error ? Do all the sheets start from cell A1 like your sample ? The code will basically copy all the sheet into sheet "EXPIRED BILLS" irrespective of the sheet name

[cyee]

How about now ?

Please Login or Register  to view this content.

Opps it work!!! but how can i delete row with blank data?

[nankw83]

Is it blank or zeros ? Also, can I use column A as a reference to delete the rows ?

PS: Please don't quote the whole post, it just clutters the thread. If needed, just quote the needed part

[cyee]

Yes. You can use column A as a reference to delete the rows.

I realized if i run the macro again it will copy the same data one more time. Is it possible to delete original data before it copy again?

[nankw83]

Is it blank or zeros ?

Yes, that's possible but you didn't answer my question

[cyee]

It is 0 :P

[nankw83]

Please Login or Register  to view this content.

[cyee]

wow... PERFECT!!!!!!

Can i request one more change.

To input header on the first row.

[nankw83]

Hi cyee,

This should take care of the header as well & thanks for the reps

Please Login or Register  to view this content.

[cyee]

Thanks Alot!!!