Search results for query: *

Hi, I have been trying to find something on google to help but for the life of me can't track down anything. I have data in this format in a cell. 0101-6,0110-6,0101-6,0110-6,0181-1,0182-1 The data represents SKUs and the quantity our customer ordered. Depending on the order it could just...

Hi, I am trying to find a formula to pull specific text from a cell in Excel. My company's ordering system lists our skus in the followng way when we pull our orders, the sku-quantity. Example 0101-3, meaning 3 of the sku 0101. When multiple items are ordered the text for items orders looks...

Hi, I have been researching this and I am either not wording my searches correctly or I have been staring this for far to long. I have a spread sheet that outlines the calls my company gets in hour increments. But it only lists the hours in which we receive calls. Here is an example...

Hi, I need to create a report where the records display vertically instead of the traditional horizontal. The query the report needs to be based off of is something like this. Date Sales Orders Calls Rec Calls Abd 4/1 $12 2 13 3 4/2...

Hi, I am looking for a way to take spread sheet and pull totals in a cell if certain conditions are met from the data and I am hitting the wall. My spreadsheet will have the columns of Agent Name, Issue Code and Amount. Assuming the issue codes are letters and I only want a sum of the 'Amount'...

Hi, I was looking for an efficient way of convering data in excel that looks like this Bob Smith Calls Talk Work Total ATT AWT Monday 10/21/13 50 16827 7719 24546 337 154 Tuesday 10/22/13 59 18199 9405 27604 308 159 Wednesday10/23/13 57 19500 8206 27706 342 144...

Hi, I am trying to average data over several tabs in Excel 2010 without averging in zeros. I have tabs Monday, Tuesday, Wednesday, etc and need to average mutiple fileds on a totals page. I can average them like this =AVERAGE(Monday!C4,Tuesday!C4,Wednesday!C4,Thursday!C4,Friday!C4) But this...

Hi, I was looking for a way to pull information from a report that exports to an Excel spreadsheet. The spreadsheet is ugly and was looking for a way to pull just the data I needed. The report has the agent’s name on row 1 column 2. The data I need for the rep is two rows down in column 3. I...

Hi, I am trying to use the consolidate function in excel to pull data from mutiple identical spreadsheets into a master sheet. If I use the consolidate function it works fine. If I try to make a macro of it I keep getting error messages that there are too many data sources. I am trying to link...

I have an assignment to find a way to take an employees schedule and see how much time they are logged into our phone system taking calls for every two hour period. I know it sounds simple but our schedules change daily so it is never a constant. I have the representatives start and end time, as...

Hi, I am looking for a way to display the current user of a spreadsheet in one of the spreadsheet's cells. I have seen some code and I think I understand where to put the code. What I am not sure about is what goes in the cell to have the name appear??? I can get buy with some of this but alot...

Hi, I have a form that allows users to enter data for customers I have fields "Date Completed" & "Completed By". What I am looking to do is when the user populates the "Date completed" field I want to grab their network log in and put it in "Complete By" field. I have tried to use the...

Hi Guys, I am looking for a way to set up a database to track customer issues. The wall I am running into is I want the users to be able to add notes that once entered can not be changed and the ability for the next user to add notes if needed. I am trying to create a sort of audit trail to...

I have a query that I have three tables joined. The join properties are all set to only include rows where the joined fields from both tables are equal. The tables are erors, employee list and supervisor. Most of the query columns are from the Errors table. Then I have a "supervisor" column from...

Hi, I am looking for a simple way to capture the user name of the person who is printing a report. I am just looking to have their name print on the footer. I am not looking to have it stored anywere. I am able to capture the user name when people enter data, but everything I try to capture it...

Is it possible to print a report based on the current infomation entered in a form set up for data entry? Ideally, I would like to have the user click on the enter buttong I have created to enter the record, and then have the report appear to be printed based off of the info just entered. Is...

Hi, I have seen several mentions hos this DTpicker. I can not find any basic(extremely)instructions on how to set it up. I am looking to have my users click on the down arrow, have a calendar pop up and them select the date they wish. Any help would be appreciated. Amy

This may be somethng easy but for the life of me I can't figure it out. Is there a way to set up a form to close automatically after the add record button is clicked? Thanks for any help. AMY

We keep having issues where people stay logged in to databases for days and days. Because of this we can not go in and make updates when we need to. I was looking for a way to have the database shut down after a certain amount of time. Like maybe after 6 hours or 8 hours the database closes...

I am looking for a way to mark a record printed in the table after it is pulled up in a report. I have tried a few things I have seen but they are not working. Each record is assigned a number in the table and they are part of the report. When the report is run it asks for a starting date and an...