In over my head again.
I'm trying to create a macro that will
1. Copy input data (Range named "FacData", cells W5:AC5 on sheet Input).
2. Find the appropriate sheet based on range named "DataMonth" -- I.e. "JAN" (to sheet Jan_Payer_Entry), "FEB" (to sheet Feb_Payer_Entry).
3. Go to the appropriate row based on "Fac" input, and appropriate column number based on "DataDay" value
I've tried several variations (even Chat Gpt generated code).. nothing working. File is attached. My last macro attempt is "A_CopyFacDataToSelectedSheet()"
Help.
Bookmarks