Forum Discussion
Copy data from one table to another ordered by date
Hi everyone, Hope you are well. I get by in excel and able to use the most formulas for my needs. However this one has stumped me. I have a table with employee details within. I basically...
matt0020190 I suggest you look into Pivot Tables. No complicated formulae, no macros. Attached a simple example based on your sample data.
Thanks - saw this but only wanted to avoid due to the formatting aspect that doesnt suit my table destination. However will have a play and see what works