Macro/VBA Help - Copy dashboard input to separate sheet - table

[dpabsher]

Howdy team,

I'm hoping that this isn't a terribly newby question. I'm attempting to use Excel in a way that it's not really meant for. I'm using it as a end of shift note taking and reference dashboard.

I need assistance in figuring out how I can automatically copy everything from the input SHEET to the Table SHEET based on year and month. Both the Year and Month are in separate cells. And all the input cells are in merged cells throughout the input Sheet. I think if I had a way to select the cell in Column 'C' that corresponded to the year and date, I think I can figure out how to copy everything over.

 

[Fluff]

Duplicate to: Macro to select cell based on year and month reference cells -> Copy text to table

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.