Copy & Paste Data to specific column

[justusthh1]

Hello!

I need your help

I want to copy data from one cell in a workbook (input cell always stays the same) and paste to a different output workbook. In the output workbook the data should be pasted to a fixed row and for the column it should be pasted to the column for the previous month. January data is in column C. To make an example: The paste range starts in column C which equals to January. If the VBA runs today (May 24), the data refers to April and should be pasted in column F (column C + 3).


Input workbook: Input.xlsx
Input worksheet: Overview
Input range: A1

Output workbook: Output.xlsx
Output worksheet: Dashboard
Output Row: 1

Can somebody help me with this? This would be super great

THANKS A MILLION!