Actual Service Request: "We need a way to create refreshable reports in Excel from our SQL-Server data source." (Made2Manage MRP System in this case)

FastLiveHelp Solution: We were able to save this company a great deal of money by accessing the database directly instead of building view-only reports within their MRP system which required seat licenses for each user. By going directly to the datasource, we were able to provide them with far more viewing stations without the need for application seats. The programs were written to be dynamic and reusable so that the building out of various reports as the needs arose was very economical. We were able to provide this service at a flat rate fee. If you need an application like this, please be sure to submit your own quote request along with your project specifications today!

Actual Service Request: "I need a way to have Excel updated with yahoo stock price quotes."

FastLiveHelp Solution: We used Excel VBA to provide a simple "Refresh" button that looks up price quotes from the Yahoo! website for the trading symbols indicated in the file. The solution was built to be very flexible so that the user could place these symbols and the desired output anywhere in their workbook. We were able to provide this service at a flat rate fee. If you need an application like this, please be sure to submit your own quote request along with your project specifications today!

Actual Service Request: "I need an Excel database application to go to a certain web site, extract names and addresses, and then put them in the excel work sheet under field headers so I can later use them in a mail merge with MS Word."

FastLiveHelp Solution: We were able to build a custom application for this individual which provided an integrated browser window so that they could browse to their selected website and then run our data mining program which extracts tabulated data from the given page and places it into a new Excel workbook. We built the program to be as flexible as possible so as to work with a wide range of tabulated websites and the program also enables the user to specify which "Next Page" link to follow in order to automatically scroll through Alphabetically broken up listings without user intervention. We were able to provide this service at a flat rate fee. If you need an application like this, please be sure to submit your own quote request along with your project specifications today!

Actual Service Request: "How do I sum a column of values matching two criteria in my spreadsheet?"

FastLiveHelp Solution: This person needed the functionality of the Excel SUMIF cell formula but with a twist. He only wanted to sum cells with corresponding cells that matched TWO criteria. For instance: Size=30 and PartNumber="123XYZ". FastLiveHelp sent him a custom built Add-In for Excel which gave him a new cell formula to use called SUMIF2 which allows him to specify two criteria ranges and values for the precision control he needed for the flat rate fee of only $35.

Actual Service Request: "I need to be able to open a file-explorer type window from within excel, select multiple text files and then click ok to import them all into excel in one go, each file becoming a different worksheet of data."

FastLiveHelp Solution: We were able to build a custom application for this individual which used a standard File Open common dialog box to let him select multiple text files from anywhere on his computer. The program would then create a worksheet for each file individually and import the data from them to each respective sheet. We were able to provide this custom solution for the flat fee quoted price of only $35.

Actual Service Request: "We need to reformat a set of worksheets to be loadable into a database."

FastLiveHelp Solution: This individual received a file with over 20,000 records laid out in a way that was impossible to use for a database import. We had their reformatted solution ready for them in less than an hour after receiving the files.
 

Actual Service Request: "How do I mail merge from an Excel spreadsheet?"

FastLiveHelp Solution: Using our Virtually Onsite Assistance service, this individual was able to connect their computer to ours so that a technician could quickly and easily demonstrate how to perform this task. This saved this busy person a lot of time digging through books and web pages. We find that many people learn better when they actually see the solution right on their own computer instead of just reading about it.

Actual Service Request: "I'm having trouble using VBA in Excel 2000. I am trying to copy a range of cells from one workbook to another one. However, the macro is failing to select the range to copy. It is simply copying the cell which is active on opening that workbook. It is then also failing to copy to the correct cell which I have indicated using the range command. Can you help?"

FastLiveHelp Solution: This person had VBA experience but was simply facing a specific problem in which help was needed to move on with completing the project. We had them send us the file they were working with and included the additional code necessary to accomplish the task. Then, using our Virtually Onsite Assistance service, this individual was able to connect their computer to ours so that a technician could quickly and easily demonstrate which changes were made and why they were necessary. This saved this busy person a lot of time digging through books and web pages. We find that many people learn better when they actually see the solution right on their own computer instead of just reading about it.

Actual Service Request: "I need to lookup part numbers in my excel file."

FastLiveHelp Solution: This person was new to Excel and had no VBA experience. Through a series of questions and answers a technician was able to determine that the best solution would be to integrate VBA functionality directly in their existing file. The file consisted of worksheets for inventory locations in which each worksheet had a series of Racks, locations, and bins upon which they needed to be able to enter a stock number, have the description populated automatically and have the master list keep track of total on hand quantities even when the part was used in multiple locations on multiple worksheets.

In order to minimize user interface issues and make the program intuitive, the solution developed used event triggers to watch for user entry in stock number and bin transaction cells. This meant that no buttons or forms were needed for the transaction processing.

Solution turnaround time was within 24 hours of payment and the entire project was done for only $65 (custom VBA projects average under $40) including a custom set of instructions for reproducing the programming in another file and Virtually Onsite training.

Actual Service Request: "I am trying to sort out any duplicates in my three columns. I am not sure how to do this. My data is bunch of user ids and domain names. Please help."

FastLiveHelp Solution: We had this person send us an example file in which they were looking to highlight any cell that was duplicated in any other row or column on the same worksheet. We built a dynamic solution which allowed the user to specify the range of cells in which duplicates were to be flagged and then highlighted them in red text as requested. Due to the nature of this worksheet, duplicates were difficult to find with more traditional methods in Excel.

Actual Service Request: "I am a excel beginner, have some basic knowledge. I need help with creating formulas. Is there a money back guarantee if I sign up with you but do net get the help I need. Here is a sample of one condition I need: In a column, lets say A1 to A100 filled with single digits, whenever there is a one digit increase from one row to the next, I want these two cells marked "red". e.g: A 1 6 2 8 3 7 4 7 5 8 6 5 7 1 8 2 9 8 10 9 . . 100 In this example, I want cell A4 and A5 marked red and A9 and A10 marked red."

FastLiveHelp Solution: Through a series of questions and answers, we were able to quickly identify the full scope of what this individual was in need of. This project turned out to include complex conditional formatting using multiple nested formula conditions. We first sent a file showing a working example for approval and then sent a Word document with step by step instructions with screenshots for reproducing the solution on their own.

Actual Service Request: "I can't figure out to do a merge document. I just want to put in first names from a list of first names. Help please."

FastLiveHelp Solution: Using our Virtually Onsite Assistance service, this individual was able to connect their computer to ours so that a technician could quickly and easily demonstrate how to perform this task. This saved this busy person a lot of time digging through books and web pages. We find that many people learn better when they actually see the solution right on their own computer instead of just reading about it.

Actual Service Request: "I am having difficulty with Mail Merge"

FastLiveHelp Solution: Using our Virtually Onsite Assistance service, this individual was able to connect their computer to ours so that a technician could quickly and easily demonstrate how to perform this task. This saved this busy person a lot of time digging through books and web pages. We find that many people learn better when they actually see the solution right on their own computer instead of just reading about it.

Actual Service Request: "I need an Excel database application to go to a certain web site, extract names and addresses, and then put them in the excel work sheet under field headers so I can later use them in a mail merge with MS Word."

FastLiveHelp Solution: We were able to build a custom application for this individual which provided an integrated browser window so that they could browse to their selected website and then run our data mining program which extracts tabulated data from the given page and places it into a new Excel workbook. We built the program to be as flexible as possible so as to work with a wide range of tabulated websites and the program also enables the user to specify which "Next Page" link to follow in order to automatically scroll through Alphabetically broken up listings without user intervention. We were able to provide this service at a flat rate fee. If you need an application like this, please be sure to submit your own quote request along with your project specifications today!