Hi all. New user here needing for help. Also not versed well in excel but can follow the instructions.
Overview: I've attached my workbook here which has 3 worksheets - "Main" with rota and duty no , "Duty No" with duty numbers and start + end times, "GCal" sheet is where I want duty no & times to export to google calendar. Rota numbers start from 1 to 62 and each lasts for a week starting from Saturday. On "Main", I've transposed the values for row table but currently all formulas are used on column based table. I'm not sure which is better suited or easier to work with but anyhow row based table is only for information.
There are 2 macros on main: Dates & Duties. Dates takes start and end dates from F2+F3. This macro autofills the dates on "GCal" B2 Column. Duties button autofills column G (Description) with Duty number on GCal from G3 based on G2.. Macros are only for testing at the moment but will further explore later and definitely will want to implement on the final workbook.
Issues: There're few but as I'm newbie will want to go one at a time.
1) I've used combination of address & match functions to retrieve desired row no on main sheet (F4). I want to pass this address eg A15 to a ROW function on GCal sheet (cell G2) which has =INDEX(ARRAY,ROW(here),2). I tried pointing to sheet!F4 but it's returning value from row 3 and not from row 15.
Thanks.
Bookmarks