Fill in cell based on relative position of other cell

[MaxTiger]

Dear all,
I was wondering if it is possible to fill in a cell relative to the position of an other cell. The distance between the columns between the “anchor” cell and the cell that has to be filled is known. I was wondering if there is a simple way to this. I have made a small example in excel to show you what I mean. Right now my solution is placing an if function in every cell, but I doubt that this is the easiest way.

Say that I have a daily schedule that varies every day, and the moment I eat dinner (for some the most important moment of the day haha) is my “anchor”. I know that at day 1, I wake up 12 hours before I have dinner, and watch a movie 3 hours after I had dinner. I know that in reality this is not important, but it is based on a production environment where it actually makes sense. Someone that can help me out? Thanks!

Max

[Bernie Deitrick]

This will work on your Sheet2, if the values in columns A to H are values, and the 'Dinner' entry is made in row 3, row 7, etc: (And the values to enter offset from it are two rows above, and the column differences are one row above, the row where dinner is entered) If your actual structure is different, then the code will need to be adjusted, but I hope you see the logic to the code....

1) Copy this code.
2) Right-Click the sheet tab of Sheet2.
3) Select "View Code"
4) Paste the code into the window that appears.
5) Save the file as a macro-enabled .xlsm file.
6) Make changes as needed

Please Login or Register  to view this content.

[FlameRetired]

MaxTiger when you do this with the IF it is evident you are referencing A1:H6 of 'Sheet2'. Are willing to have M1:AK10 included in a formula?

I believe I see a possibility for a formula solution if you are. It will be long and complicated due to the layout of both sheets, but doable.

Before investing the time please let me know if that is acceptable or whether Bernie's macro does what you want.