Hello everyone,

I am a beginner with macros and VBA but would like to learn / use this excel function to be able to quicker process the large amount of data I have to handle for my dissertation. Help would be much appreciated

This is what I have:
In one worksheet, I have names in column B and dates in column C. I have included a drop down filter so I can view only the e.g. 2011 entries.
Now, I would like to copy all 2011, 2010, etc. Names and Dates to separate worksheets (i.e. one worksheet for 2011, one for 2010, etc.).
By using "Paste Special" - "Transpose", I can copy and paste the names and dates so that they appear horizontally in the form Name1 Name2 etc. in the first row and underneath in the second row Date1 Date2 etc.
For each Name I will then insert a formula.


This what I need:
Name1 and Date1 are in the same Column A, and Name2 and Date2 directly follow in Column B. But because I will insert the formula, I will need 2 columns per Name. Therefore, I would need to insert a blank column after each name.
Now, is there a way how to avoid doing this manually for each Name since I have a large number of data?

Hopefully I was able to explain what I mean and what I need, please feel free to ask for clarification.

THanks a lot in advance
Elisa

PS: I am using Excel 2007