Share via

Auto-populate data from Master sheet into separate tabs

Anonymous
2017-12-18T16:27:53+00:00

I would like to auto-populate the data from my Master sheet "Open Bookings" based on the customer to a separate tab for that customer. I have tried several formulas and VBA codes, but its not pulling the data. 

I have 15 customers, which means i'm currently having to manually input this data for every tab. If I could automate that process it would save me so much time. Thanks in advance, i've attached my worksheet. 

The Document in Question: https://***

[PII is masked by the moderator]

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Ashish Mathur 102K Reputation points Volunteer Moderator
2017-12-30T00:15:00+00:00

Hi,

There is no mistake in your formula.  Here is what i see on the POET worksheet.  I just went to cell A2, pressed F2 and then pressed Ctrl+Shift+Enter.  I then copied the formula down/right.

Was this answer helpful?

0 comments No comments

11 additional answers

Sort by: Most helpful
  1. Anonymous
    2017-12-21T18:50:13+00:00

    I'm familiar with Pivot Tables, I played around with that option before posting here. I'm looking for a VBA code. Thanks though.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2017-12-21T18:30:47+00:00

    You can make a PivotTable look pretty much exactly like its data source, it just takes some experimenting.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2017-12-21T15:42:17+00:00

    This option only auto populates certain parts of the data, based on filters. I need the data to replicate exactly the same from the master sheet to the sub sheets.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2017-12-18T22:45:00+00:00

    If you create a PivotTable from your master sheet, you can put Customer in the Filter field, then use the Show Report Filter Pages option, which will create a new PivotTable worksheet for each customer. As you add data, just refresh the PivotTables to update the information. No VBA required.

    Was this answer helpful?

    0 comments No comments