VBA to Populate Data Across Tabs

Copper Contributor

Hello everyone, I have a spreadsheet with customer information with a tab for each month of the year.

The columns in the table include customers name (Column A), phone number (Column B), address (Column C), preferred location (Column D) etc.

I would like the spreadsheet to automatically populate the corresponding data when the customer's name is entered into the column A, so each time the customer visits I do not have to copy and paste or re-enter the information into the remaining columns. I would like this to work across each tab (if a customer visits in January for the first time/I enter their data for the first time in January and they then revisit in April, I would like to enter their name in the first column and the other columns generate automatically.) Any tips on a moc VBA? TIA.

0 Replies