Using master sheet ( constant updating), copying entire row to another worksheet within the same-workbook.

[Szucchari]

Hi everyone,

I have multiple worksheets within a workbook: Master, Kitchen, Bar, Patio, Office.

On the master sheet, Column A defines which tab the row would belong to, i.e. Kitchen, Bar Patio, etc. What would be the best way to automatically copy over rows from the master sheet to another worksheet depending on column A of the master. Also, update their lists depending on what is done to the master. If I could keep the conditional formatting that I have on the master that would be great but if I can't its fine.

If A1 on the master sheet says "Bar", I need the entire row to copy and paste into the Bar worksheet.
If Row 1 is marked "inactive" on the master sheet I have conditional formatting that will make the whole row turn red, if there anyway for it to automatically update the color on the other worksheet the data is copied to? If there is a better way than conditional formatting I am totally open for suggestions!

I am not opposed to a VBA macro, I am pretty sure it is my only option but I am a complete noob, I really would like to learn but I don't know much at all. So I am apologizing in advance if I drive anyone crazy with nonsense questions.

 

[Trevor_S]

I think it would need to be a macro, but you would need to consider what would trigger that macro. For example, how would it know if you were amending an existing row that had already been copied across, or creating a new row that would then need copying?

But, taking a step back, do you really need separate sheets? If column A indicates the area that the row relates to, couldn't you just put a filter on column A? Then if you want to look at all the rows relating to a particular area, select it using the filter. If you need totals for any column, instead of using =SUM(cell from:cell to), use =SUBTOTAL(9,cell from:cell to). This calculates the total of visible rows only.