Forum Discussion
Reverse data, and automatically copy in values
Riny_van_Eekelenhttps://broharsjoen-my.sharepoint.com/:x:/g/personal/knut_brharsjoen_no/EZaKqIRACNxNsAQ6xi-jLCEBeEZpLeywV44PknwD8cLLrQ?e=U8dQTB
Here is the file, and how I shows in the template after I paste in the raw material. The only difference in the desired outcome is that the dates come in order automatically. As you can see in the file the newest date comes first. I would also like for the data to be copied in as only the values in the last spreadsheet, so you can edit the text manually.
Another smaller problem is that the raw data vary in size, so in the last sheet the rows not used appears as 0 since the formulas are not used. It's not a big deal since I can only delete them, but is there a way where I can make them automatically dissapear if not used?
So "Ark1" contains the output from the time system. "Ark2" links cell-by-cell to "Ark1". And, in turn the "Detail" sheet links to "Ark2". Not sure why you would have these extra steps. Why not just take the data in Ark1, get rid of the formatting and transform the data into a structured table. And then just sort all by date in ascending order and do the edits you need/want.
Being on Mac you don't have the option to automate such "transformations" via Power Query, so you would need VBA if you can't do what I described above. But VBA is not my thing. Sorry.
- we use "detail" as an Invoice basis. The template is therefore used to effectively produce these instead of manually editing each excel file every time we fill in raw data from a different project. It also reduces the risk of losing data in editing. (the excel competence in the firm is quite low)
However I do think I have Power Query since the last update, even tough it is Mac.KnutHarsjoen The PQ feature you see on the Mac is very limited and not what you would need, as you can not do any transformations. Just connect and load.
- oh ok.. Thanks for the help anyway!