Hi,
I am totally new to Macros. I have a worksheet named "Raw File" which is sent to me every 2 weeks. The column position and their headings remain the same, but the number of rows changes. It contains historical and current month information.
Thus I want to copy this whole data (for specific columns) into a new worksheet called "Main File". Again in this file the column position and their Heading would remain the same always. However, I need to calculate some numbers on the basis of current month information. Like Year Till Date (YTD) = sum of values till the current month. Every time the month changes, the calculations should automatically change i.e sum should include that month's data; the division should be done by that month's Number (eg. Jun =6; July =7)

1. Thus I need a code which can copy the specific data.
2. Also, ask the user to choose the latest month and basis that make the calculations.
3. Look up at some base files to pick related information. Eg Base File 1,2,3
4. Group values on the basis of Family Name. Eg. Family id is unique and final information is to be combined on the basis of Family names. The Prod ids are also unique, but many prod id can have same Family id.
5. And display information in the format as Worksheet "Öutput File".

Its too huge and complex for me to explain properly. I tried to search on the net and do this myself, but got confused. Any advice would be a big help to me.

Thanks in advance.

I am attaching the excel workbook for better understanding.