I have a workbook (attached) where the Current Transactions 2018 tab is the master sheet. I want 4 other alternate sheets (CA Client Boards, AZ Client Boards, WA Client Boards, & UT Client Boards) to automatically populate with the fields listed in the header row on the next available line when someone updates the master sheet.
Basically - 2018 Transactions.xlsx
IF the POD States: Folsom CA - data should transfer to the CA Client Boards
IF the POD States: Phoenix AZ - data should transfer to the AZ Client Boards
IF the POD States: Everett WA or Federal Way WA - data should transfer to the WA Client Boards
IF the POD States: Salt Lake City UT - data should transfer to the UT Client Boards
I've tried some formulas and reviewed Youtube and Forums for a VBA that would work but I just can't make anything work as I'm just not that familiar with VBA to understand where I'm going wrong. Currently I've hidden the columns that I don't need transfered in the secondary sheets thinking I'd need all the header row to match.
What I'm trying to accomplish is less data entry in several different places for our people who update the master sheet. We will then add additional columns to the secondary sheets with other data we want there.
Thanks,
Kelly