Auto populate cells to one sheet from sub-sheets in Excel

Ask a question jjtufu - Last answered on Aug 4, 2017 at 04:41 PM by ac3mark

I am currently working with a spreadsheet that already has 7 worksheets total with a table on each. 6 of them have identical Table Columns but the main one has a few extra columns. One column labeled "Form #" is somewhat the same across all sheets besides the fact that they are categorized by department so only one sheet includes all the form #'s and the other 6 sheets have only the form #'s that pertain to their labeled department.

What I would like to do is whenever I update a cell on any of the "sub sheets" that are separated by department, it will update on the main sheet as well so it is the same across all sheets and the master sheet has every sub sheets information included in a table. The Table Columns names that I would like all to be updated simultaneously are Form Status, PDF, Signature, Spell Check, Notes, and Time to Completion with Form # being the primary column.

Any advice or help with what the code would be and the process of getting this working would be greatly appreciated.

plus moins
OK, take a look at this article, and see if any of the cut and paste at the end does what you are looking for!

Please bare in mind, that we can help with code, but we do not provide turn key solutions.
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!