If you have an Microsoft Excel workbook with multiple worksheets that contain similar type data it may save you a lot of time to auto populate the other worksheets with the similar data. In my scenario I had a form used to obtain information about customers which needed to be in a certain format but then I had two other forms that had some of the same data that needed to be provided to other departments. So the initial process was to fill out each individual form by hand and send to the proper department. To save time I wanted to auto populate as many like fields as possible.

The resolution ended up being really simple. First I just added the other forms to the workbook of the primary form. This ensured that when I opened up the form to enter customer data that the other two forms were open with t. Once I had added the worksheets and named each one properly I started messing around with formulas to complete the task of copying one cell from the primary worksheet to cells on the second and third worksheets in this workbook.

Read the rest of this entry »

Its fairly easy to merge Microsoft Excel fields together but you have to be aware of formulas and then with how to pull that data out of the formula to save it on its own. I used this to merge title, first name, and last name together. Follow the directions below and you should have no problems merging Excel fields together.

1. New Column: Add the below formula to a new column.

=CONCATENATE(A1,” “,B1,” “,C1)

Read the rest of this entry »

Below is a step by step guide to export your Microsoft Outlook contacts to Excel as well as a step by step guide to export your Windows Mail to Excel. If you are running Windows Vista follow the Windows Mail steps and any other Windows version, including Windows XP, should use the Microsoft Outlook steps.

Export Contacts from Windows Mail to Excel:

1. Open Windows Mail: Click Start Icon, Click All Programs, Choose Windows Mail
2. Select Contacts: From Windows Mail Select Tools, Select Windows Contacts, Left Click Windows Contacts.



 

Read the rest of this entry »

When I was attempting to attach files to Microsoft Outlook 2007 the drop down to switch folders hangs forever as does clicking on folders. Sometimes it would hang so long that the window would show “Not Responding”. Eventually it would unlock and allow me to choose a folder only to hang again if I was drilling down even further. The same problem with very slow navigation when opening files would happen with Microsoft Word 2003, Microsoft Excel 2003, Microsoft Visio, and any other MS Office products.

I initially thought the issue was a problem with my laptop overheating or a possible issue with the pagefile on my laptop. It turns out the issue was the fact that I had configured some network drives to attach when I was on a remote companies network. Every time I was attempting to attach a file and was switching folders or directories it was having to wait to timeout the network drive that was not even attached.

This can be resolved by the following steps.
1. Right clicking My Network Places and selecting Disconnect Network Drives…
2. Click and any network drives that show in here that you do not connect to every time you boot your computer
3. Click OK to close Disconnect Network Drives

Test attaching a file to MS Outlook and navigate through your folders which should now be much quicker!