Home

Data spreadsheet

Singh89
Occasional Visitor

Hi there, I am new here, and wanting to get some advice on a spreadsheet I am making for work, I am going to have to venture into the world of visual basics, and this is new for me. I am wanting to create a code which will send names to specific sheets.  So I have created drop down bars with yes or no options if a worker selects yes on three rows I want the name to go to the wait list, if they select three no's I want it to go to the unsuccessful list - do you have any advice on how I can do this, I have very limited skills but am a fast learner.

1 Reply

Hello,

 

the best approach is not to duplicate the data. Instead of using VBA to copy the data, you can create a report that filters the data on the entry sheet to show only the rows you want to see. 

 

Enter your data into one flat table, no blank columns, no blank rows.

Turn that data entry table into an Excel Table object (with Ctrl-T), then new rows will automatically inherit formulas, formats and drop-downs.

Click any cell in that table and Insert > Pivot Table on a new worksheet.

Drag the fields you want to see into the rows area, format the pivot table to use a tabular layout.

You can use filters or slicers to show only the data you want to see.

 

This is just a rough overview of the steps. There is a lot more detail to this, but there are lots of tutorials about pivot tables on the web.

Related Conversations
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Loading spreadsheet with notes in cells into Teams
DaleA123 in Microsoft Teams on
0 Replies
How often the sync is triggered?
HotCakeX in Discussions on
5 Replies
Spreadsheets with mobile access
darciwilliams in Microsoft Teams on
5 Replies