Creating a template with Macros.

[VRampras]

HI guys ,

Am new into Excel Macros... And am trying to create a template which reduces manual work. I need some help to reduce the number of macros and in a range populate data for cells required and rest display as empty.

1.Firstly I certain Columns from sheet Salesforce and paste it in Sheet Prospects.

2.Secondly in Prospects Sheet calculate Start date which is a month from the value in the close date. And a Condition If date >15 .Like 27/05/2011 the the calculation should be 1/7/11.

2.1. In same sheet i calculate the span which i populate using a vlookup function using the table on sheet1.

2.2.I calculate probability amt using amount column and the Probability %.

2.3 Then i calculate billing days from there using a formula.

once all is done.

3.I copy the required colums into another sheet called sheet 2.

I need to minimize the number of macros and dont want to display #na or ) when there is no data.

If some one can help me with this that would be so helpful.

[docMed]

Try restructuring this and proof-read your posts in the future. It's difficult enough just to help an individual with macros, let alone sort through such a jumbled mess.