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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies