Hello!
Its a work schedule xsl file., where I have a sheet (lookuptable - named legend), where i have letters with the values they have.. I am using the letters in hours count etc..
In the sheets where the hours are counted
I need to present which letters mean what. (letter meaning)
At first I just made it manually.. like letter A means 8 work hours with the working time 13:00- 21:00 in short in the file
A - 8h 13:00- 21:00
Then the times changed
I started using pointing out certain cellvalues where needed like that:
=(Legend!C12) & "=" &(Legend!D12) &"h " &(Legend!E12)
But then New letters appeared, and since my formulas need my lookuptable(legend) to sort the letters AtoZ after adding a new one
then the pointing out a certain cellvalues got messed up also.
Now im looking for a solution what in my head should be something like that:
when i want to add letter a
check lookuptable column to have letter a, if yes then get letter a celladdres and then enter data from celladdress+nextcolumn+next column
a+8h+13:00-21:00
including a sample file for better understanding.
Bookmarks