Comments
-
@Genevieve P. Thank you for the response. I did read that in my research yesterday, however, was hoping there was/someone had devised a clever workaround? I have a secondary report where we can fairly easily affect recording of the dates. Due to the fact that the Source sheet for $ values and the dates are two different…
-
@Andrée Starå I believe I am running into this very same issue. I have 80+ budget worksheets. Then I have a report pulling a specific row from 80+ budget worksheets. I need to enter a $ value in this row which translates back to an entry in each of the 80+ budget worksheets. This $ value also then works its way into…
-
@Andrée Starå THANK YOU! I used an Index/Match formula WORKED PERFECTLY!!! LOVE this community.
-
@Darren Mullen The 3 'GC Bid sheets' look exactly the same only with 1 column for their individual bid. @Andrée Starå This solution would be used over and over again by our team. I thought I could use DataMesh, however, DataMesh goes across the sheet (left to right) whereas I need data from one entire column ('GC #1 Bid)…
-
@Danielle Arteaga WELL that was an out of the box solution that actually works!!! Simple, easy, unconventional, but works. Thanks!!!
-
@Andrée Starå Three leading zeros is the max
-
@Andrée Starå This works beautifully until text in the cell is '0010' or '0100'. In these instances I need to return '10' and '100'.
-
AGREED - A MUST !!!!!!
-
@Jake Gustafson @Frank s THANK you for the question @Jake Gustafson and THANK YOU for the answer @Frank S. I have a situation where 83 worksheets are shared to the same individuals (external partner). We have had a request twice now to add 'so and so' to the access of these same 83 worksheets. If we had employed sharing…
