Forum Discussion
Casen_
Jul 17, 2023Copper Contributor
How to duplicate column based on date?
I have a locked down workstation and can only use the basic Office 365 tools. No scripts or VBA. There are two requests: I have a sheet named "Matrix" that is just columns of a date range and ...
mathetes
Jul 18, 2023Silver Contributor
What you're seeking to do is probably not all that difficult. It IS difficult, however, to work with images alone and test a formula. So, in effect, you're asking us to re-create the workbook/spreadsheets on our own so as to test any formulas we might suggest. [There may be a few of the experts here who are confident enough to write a formula without testing it; I'm not one of them!]
You could help us help you--your workbook is already using no names, so there is no issue of privacy being violated--by posting the actual workbook(s) on OneDrive or GoogleDrive, with a link pasted here that grants access
- Casen_2Jul 18, 2023Copper ContributorI apologize. My work computer and phone have different accounts and my phone is auto logging in a different one.
However, here is the link: https://docs.google.com/spreadsheets/d/18PfLib8g3TZTRufQ2R58uMlNYlEvuj8i/edit?usp=drivesdk&ouid=104862895633418872032&rtpof=true&sd=true
Thank you for looking.- mathetesJul 18, 2023Silver Contributor
- Casen_2Jul 18, 2023Copper Contributorhttps://www.dropbox.com/scl/fi/nt17q8i1103162sf4oxt3/Flight-Matrix-Redacted.xlsx?rlkey=e5o8ym0tlyv6ie038wandk8gw&dl=0 Let's see if a drop box link is better.