Forum Discussion
SophieD17
Nov 04, 2022Copper Contributor
Creating new rows when unique values found
Little back story - I'm putting together an accommodation spend tracker that has all our booking data on one tab and the analysis on another. We have multiple projects with new ones starting all the...
mathetes
Nov 05, 2022Gold Contributor
Is this something that is possible or am i trying to make excel do something it can't?
I'm quite confident that what you're trying to do IS something Excel is entirely capable of doing.
However, it's not really all that clear what it is you're trying to do. It would help a lot if, in addition to your verbal description, we could see the actual workbook(s) (or similar replicas--same format, fictional data).
Would it be possible for you to grant us access to the workbook(s) you currently have? You can do that by posting the file(s) (devoid of confidential information) on OneDrive or GoogleDrive and posting a link here (please make sure we have more than "read only" access).......