Search results for query: *

I have an autofilter set up through VBA in an Excel 2007 worksheet. Once it filters, I want to delete all the values it returns and remove the autofilter. The problem I'm having is how to select the first row of the filtered data- sometimes it's row 2, sometimes it's row 456. How do I select...

This might be an answer that is super easy, but I can't quite figure out how to do it. I have a macro that inserts a column as part of a larger procedure. The problem is that there are formulas based on this data on other sheets that change when the column inserts. For example, the formula...

Hi Everyone, I have a Dell Inspiron 6400 Laptop that I bought 3 years ago. Performance wise it hasn't failed me yet, so I'm not looking to replace quite yet. One problem I have is that I'm very low on hard drive space. I recently dropped under 1GB available on my C:\ drive. When I bought the...

Hi everyone, I have an Excel workbook that I'm having some trouble with. Here's the formula that is giving me trouble: =COUNTA('Data'!AB:AB) In the sheet 'Data', there is a formula in column AB like this: =IF(D2<>"Part Executed",T2,"") =If(D3<>"Part Executed",T3,"") When the COUNTA function...

Hi Guys, I have an Access form with a command button that will copy certain fields to the next record to be entered. The code for that button is: Private Sub Command367_Click() Me.BuySell.DefaultValue = "=" & Chr(34) & Me!BuySell.Value & Chr(34) Me.TradeDate.DefaultValue = "=" & Chr(34) &...

Hey everyone! I have an Excel 2007 spreadsheet containing 2 columns of names. One with last name, one with full name. I was wondering if there is any way to check the list of full names to see if it contains any of the last names in the other column. If there is, highlight the full name that...

Hi All, I have a table in excel that has Y-axis of Share Price, X-axis of Price per Share, and the data in the middle is the associated charge. I want to be able to add a certain amount to cells that have a principal amount between certain ranges. For Example: Price...

Hi Guys, I've been having some major issues with a workbook that I have to distribute throughout my company. It's a basic solver application, but as expected not everyone has solver. I've tried several different methods that I've found, but I can't seem to (a) consistently get the solver.xla...

Hi Everyone, I'm not sure if I should be posting here or in the VBA forum, but I think that starting here would be good. I have a spreadsheet with 38,000 lines in it. They contain data from stock trades. When buying or selling a stock, the shares don't always necessarily get bought or sold in...

This is both a report and a query question. I have a table with the following fields: Date Rep Quantity Price I want to create a report that takes the sum of (Quantity*Price) for each rep on each day of the month specified in an unbound form that launches the report. In the end, I want to...

I have a list of names in the format LastName, FirstMame. The whole text string is in one column, not separated into two separate columns like I need. Eventually this whole spreadsheet will be imported into Access. Is there a way I can write a script to go into each cell of the column, select...

Hi all, I think this is a pretty easy question. I've looked in a couple of beginner books and online and I can't quite find what I'm looking for. I have a table tblBlotter. In this table I have fields RepName, Quantity, Comission, Date. Basically, I eventually want to create a report that...

I didn't want to piggy back this on the other question I just posted because I haven't been able to find an answer in past questions. I set the default value of my controls with this method: Me.SecurityDescription.DefaultValue = "=" & Chr(34) & Me!SecurityDescription.Value & Chr(34) I want to...

Hi Everyone! I have a form, frmNewTicket, that I would like to add a command button to. Right now, everytime someone goes to add the next entry, they have to re-enter a lot of data. I would like to add a button that will bring up the form for the next entry, but automatically fill in some...

I have a worksheet with 2 pivot tables with criteria options of Apple or Orange. There is a separate drop down combo box with 2 options: Apple and Orange. My goal is to have the value in the combo box change the criteria of both pivot tables. Right now, the combination box sets the value of...

I must admit, I'm pretty new at database design, but I have tried really hard to keep standardized naming and relationships as well as asking questions about anything I'm not sure of. I built a database that works perfectly on my computer, but when I tried to use it on the end user's computer...

I have a simple report based off of a query. All 7 fields are set to be formatted as currency when displayed on the report. When opened in print preview view, 5 of the text boxes show up as number fields displaying as many decimal points as were calculated. When I go back and check how they...

Hey Everyone, I have a spreadsheet that has been generated by a different program with about 27000 rows. It has 6 columns: EXDATE,ACCT#,SYMBOL,SHARES,PRICE,and CLIENTCHARGE. I have sorted it by SYMBOL(ascending), EXDATE(ascending), then ACCT#(ascending). What I want to do is look for entries...

Hey Everyone, I have a spreadsheet that has been generated by a different program with about 27000 rows. It has 6 columns: EXDATE,ACCT#,SYMBOL,SHARES,PRICE,and CLIENTCHARGE. I have sorted it by SYMBOL(ascending), EXDATE(ascending), then ACCT#(ascending). What I want to do is look for entries...

I have database for stock trading. At the end of each day, the database creates a report of all the stock trades during that day (called a blotter), as well as totalling the commissions on those trades. The end of month report needs to be layed out in a fashion that each row is a business day...