Copy cels from one file to another based on Date

[mirenoba]

Hello every,

I am here again with another request for help. I have 2 files "Input" and "Output" (attached). I have every month new data that I put in the "Input"" file and i am wondering if is possible to make the Copy button copy values to exact column in the "Output " but considering month. I would like to set the month, then press the Copy button and it will copy an paste values from Input to Output file.

[kvsrinivasamurthy]

Pl see the attached file with macro (COPY Button).It is assumed that both files are in same folder.

[mirenoba]

It is very nice work. It will be very hard for me make some changes to adjust my original file but i hope i will manege it There is a small thing, it is copy the values only to the first sheet (Cust1), but i need to copy some values also in the second one (in my original file ine 4 sheets). How to do it?

[mirenoba]

Also is there a possibility make the code for the button not like a macro? I tried some changes like add column in each file with another characteristic but is it not working. Modified the code is harder than i expected

[kvsrinivasamurthy]

Pl post a dummy file similar to you original file.