Data spreadsheet

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



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
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies