Forum Discussion
Populating information from one excel file into another
Alright, So I have two Excel files. The first is a listing of credit cards and due dates, the second excel file is a calendar (contains 12 sheets, one for each month of the year). My question is...
Say Sheet1 is your "credit card due date list", input formulars in calendars.
(1) If you accept Date and Text in 2 rows:
=IFERROR(
OFFSET(
Sheet1!$A$1,
MATCH(A1&"th", Sheet1!$B:$B,0)-1,
0),
"")
(2) Then change a little bit to have both Date and Text in 2nd row:
=IFERROR(A1 & CHAR(10) & OFFSET(Sheet1!A1,MATCH(A1&"th",Sheet1!B:B,0)-1,0), A1)
(3) Then more changes to skip 1st row:
Replace A1 with COLUMN(cell) & (ROW(cell)*number_according_to_your_calendar) & "th"
For Date with "st", "rd" just copy, paste and adjust the formulars.