Entering data in mutiple tabs that updates a master/Summary sheet

[swarnbr]

I have a workbook that has several tabs. Each tab collects the same data from different teams. I'm trying to have a master/summary sheet get updated each time there is an entry on one of the team tabs. Entries with rows of data will be added and deleted numerous times from the team worksheets, but I want the master sheet to always display the current data available on each teams' tab. The master sheet will be sorted and filtered by other users to group data together by the Column Categories at their discretion, so no particular order is needed on the master, but I don't want to have blank lines on the master. The master could become quite long. I realize that at times the teams won't provide or won't know all the data being requested but I want to be able to display on the master what is available.

I've searched several threads, but because I really don't have any VBA experience, I have been trying unsuccessfully to write a formula. Any help would be appreciated.

[oeldere]

This code will do that for you.

If you have questions, just ask.

Please Login or Register  to view this content.

[swarnbr]

Thanks, but unfortunately I know little VB.

My bad, security got me paranoid when I asked a question. As far as I know, there is nothing wrong with the code provided. My ignorance was the problem.

Thanks,