Hello,
I need some help tweaking the attached workbook.
In the sheet "sample" you have a master worksheet which is getting data from other sheets, which are named if the format "DD.MM.", where "DD" stands for the day and "MM" for the month the data was generated on. I did not include these data sheets, because they are not relevant for what I want to achieve. That's why you see all the reference errors in the sample.
The sheet, works like this: If I would add a data sheet today, I would name it "15.10." and some of data in this sheet would be copied in the "sample sheet" in C35:H35.
Do you have any ideas to do the following:
1) After real data (and not just the reference formula) is in C35:H35, I want the number in cell I102 to be set to "52". This is the same number as in cell A35, next to the block C35:H35.
2) Then, I want the data in K103:P103 to be copied as numbers in R35:X35. This is the block next to the number 52 in Q35. The block K103:P103 changes every time after a new data sheet comes in. For instance tomorrow, we would have data in C36:H36 and this would change the numbers in K103:P103. The new numbers should be then copied in R36:X36, next to 51 in Q36.
Is there a simple way to get this done? Thank you for your help!
Bookmarks