what characters are you struggling with?
Fair enough, i have that at work as well and it drives me mad. As long as you only need the data somthing lilke this might help Sub MergeKiller...
Please add an example workbook so the question is clear and we dont have to recreate the data
Can you add an example worksheet so we doint need to recreate the data
Hello Indirect will let yoiu make the cell from the worksheet name and text =INDIRECT(A24&"!P3") Then in the grid you can have a match to...
You want column B to look like column A? 202104 only has the year and month in it?
What are the numbers? 55:51 is that 55 hours 51 minutes or 55 minutes 51 seconds
Works perfectly for me - did you look at the attached file?
All the data is text and not numbers (except the 22:00:00). Sum can only work with numbers
Not sure i understand, can you post an example workbook?
if i have understood correctly you want the date of the first sunday in the month selected? Does this work for you? =D2+MATCH("Sunday",TEXT(ROW(...
Somthing like the attached?
Please provide an example workbook as per forum rules. Re-creating data (probably wrong) that already exists is just a waste of time
I am really struggling to see what the Macro is trying to do? If i click the top button it checks E5 and then populates times in the activecell ...
Your Issue is because you are merging cells, the attached has data validation working on the top box. There are 3 main rules when using excel, 1) do...