We know Microsoft Excel is a popular construction cost estimating tool. Thus we thought we would pass along an item from sister site the ITKnowledge Exchange that offers some help with Excel 2003 worksheets.

In Can data in Excel 2003 be set up to automatically move from one sheet to another in a workbook?, a user named Kaylee asked the following:

Is it possible to create a macro, or multiple macros to…move data from one sheet to another in the same workbook in Excel 2003? [I]nstead of having to manually copy and paste information…from sheet one to the others, we would like to create a drop-down menu or button that would automatically move the data to another sheet in the workbook.

The short answer: Yes, ’tis possible. In fact, there are two ways to make it work — either create a formula to perform this task or use an add-in called a dataloader. If you want to find out more, click on the link above to visit the original post.

If information like this is helpful to you, please let us know and we’ll keep looking for more hints on making Excel a better construction cost estimating tool.

This entry was posted on Thursday, July 24th, 2008 at 4:06 pm and is filed under Estimating software. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.