Forum Discussion
Move Rows based on Date
FrameofLightDesigner Why go through all the trouble of putting everything into one list and then split it all up by year, basically duplicating the information.
Consider sticking to one list, put filter buttons on the header row. Since the dates in the list are proper dates, you can now click on the "down" arrow and select/deselect the year(s) you want to see. Same thing for all the other columns. You could, for instance, filter all orchids of the same genre, or everything bought from one particular seller.
In the attached file, I transformed your Complete list to a structured table. I re-created your list on a Mac and it will work the same on a PC. Want to add a new item? Select L165 and press Tab. A new row is inserted. Formulae for Item number and Total are copied down automatically. Alternatively, select any cell on row 165. Right-click, Insert, Table Row Below.
More about structured tables in the link below.
Riny_van_Eekelen Well, this is something I hadn't thought about, mostly because this is also going to include graphs. When I add my graphs, when I do my filters, can I make the graphs change with the filtering?
FrameofLightDesigner I believe you can. What kind of graphs did you have in mind? You can create pivot tables / pivot charts on the basis of the Complete list.
Riny_van_Eekelen So each orchid has different care requirements. So I want the graph to reflect the "average" care requirements necessary, but also a graph showing the orchid types I have.
FrameofLightDesigner Possible. Where and how do you intend to keep the "care" information? And when you talk about "types" of orchids, do you then refer to "Genre"? If so, you are dealing with 82 unique genres in the table. That's quite a lot of data labels if you want to capture all of them in a graph.
Anyhow, I've added a pivot table and a graph with a slicer and a timeline, just to demonstrate the principle. Not very pretty, though, and probably not very meaningful either. Have a look and see if this is something worth pursuing.