Search results for query: *

Hello all: I hope you can help me with the following: In cell C4, I have the following formula: $G$5. Sometimes I need to delete columns G to K, such that columns L to P shifts into place i.e. now becomes column G to K. Can you please tell me why I am getting this error since column G still...

Hello everyone: I am trying to write a macro: Sub Signature() Sheet3.Activate If [T4] > 0 Then r2 = Rows.Count + 1 [T.r2] = "Signature" End If End Sub But it's not working because I am not sure of the syntax to use. I want to insert the Word Signature in column T of the last row + 2 if T4 is...

Hello All: Is there a way to make the Print Area cover all the rows with data in a worksheet? I.e. to make the Print Area dynamic?

Hi All: I recorded a macro to higlight rows 5 to 551 and then format it. How do I modify this macro to highlight row 5 to the last row and then do the format? Thanks for helping me. SharonMee Rows("5:551").Select Range("B5").Activate Selection.Borders(xlDiagonalDown).LineStyle =...

Hello all: I was wondering if I could do the following using a pivot table: the columns in my table includes: Analyst_name Account_name # of Days Amanda Hortons 5 Amanda Speed 5 Eunice Kreme 4 Eunice Crown 4...

Hi all: Please help with the following: I want to create a drop down list in a cell. The values in this drop down also have separate values of their own which will be placed in a different drop down list. E.g. first drop down list: Breakfast Lunch Dinner second drop down list- if...

Hello all: I have the following formula in the expression builder: IIf([Delivery] Is Null,IIf([Cheque Status]="MAIL",WORKDAY([Check Date],3),[Delivery])) But I am getting a "Undefined function "Workday" in expression"? Do you know why I am getting this error? Thanks much. SharonMee

Hi all: All the dates in my table are in the medium date format e.g. 04-Jun-05. In my access query, among other things, I am grouping by the MAX of a particular date. When I run the value, the date format changes to 06/04/2005. How do I keep my original date format. Thanks for helping me...

Hi all: How do I set up a query, such that it will give me all rows available in my table except for those in which column "Check" has the word "Total". Thanks for helping again

Hi all: I am setting up a query in Access. I have 2 date colums, Since Date & Logged Date. How do I say "If Since date" is null, = logged date. Thanks

Hello All: I am thinking of building an access database, because in one of my tables in excel, the list keeps on growing, and it's making all my vlookups very slow. 1)I have 3 tables. The first one, "State" contains the raw data. In excel, I concatenate the Invoice # and the Bill Date...

Hi All: I have a couple of workbooks open (with a code someone helped with and it works fine). In my "working" worksheet, which is not included in the workbooks mentioned above, I would like to search for cell C3= Account Name e.g. Hortons and C4= Account Number e.g. 0010456 in the worksheets...

Hi All: I have a couple of workbooks open (with a code someone helped with and it works fine). In my present worksheet, which is not included in the workbooks open, I would like to search for cell C3= Account Name e.g. Hortons and C4= Account Number e.g. 0010456 in the worksheets of the...

Hello All: Please tell me if the following is possible with a macro, if so, please help me: The following pertain to Excel. I have a folder called Claims and it’s in another folder called Cost Department. In the Claims folder, I have folder called Data and workbooks that are labeled January...

Hello All: Please tell me if the following is possible with a macro, if so, please help me: The following pertain to Excel. I have a folder called Claims and it’s in another folder called Cost Department. In the Claims folder, I have folders (month folders) that are labeled January 2004...

Hi there: In my worksheet, the rows keep on shifting, so everytime, I need to change the row # in my formula. I learnt that dynamic ranges can do the trick; I actually posted something a few weeks back, but I don't understand it still and it's not working for me. I have looked at the couple...

Hi all: I hope you can help with the following: How do I write a macro that would 1) count the number of cells in column S (column 19) that has a "NO" 2) then I want excel to go to the last row and insert "Total count" in column R and the # of cells with a "NO" in column S, Is it possible to...

Hi all: Hope I can get your assistance on the following: Before I run my main code in excel, I would like to turn off the autofilter. My code runs a filter and then searches for a value. Then it runs another filter and then searches for a different value. My question is: How do I write a...

Hello all: I need your help with this macro. In column R, I have filtered the data for "NO", then I want to copy all the rows and paste then into another sheet. I am having a problem with the copy part of the macro. I want to copy anything apart from the first row of my data since that is...

Hello everyone: Hope you can help me with this macro: In cell A3 I want to put "for date between 01/06/2004 and 30/06/2004" I want excel to insert the date based on the date on the computer. If the date on the computer is July..., it should insert the first day of the previous month (being...