Search results for query: *

I have a .txt file that I am opening with Excel so I can parse some data from the file and import into another program. I have one column of data that I cannot get to format properly. Most of the cells contain numbers which need to be formated to nine digits. I can format those ok using the...

I have created a several page form with protected form fields. Upon entry of several fields a form will open for user entry. My problem is that I had set the code to unprotect the document and input the data into the document and then reprotect. The problem is, once you unprotect and then...

I am working a macro that will look in Column F for either a T or Z. If column F is either T/Z and column G is prior to 1/1/2005, I would like the entire row to be deleted. I am having a little trouble getting the code to do this.

I think this is fairly simple and I can't quite get it. I have a form that opens in Excel when a macro is ran. When the form opens, the user must select one of three radio buttons and may choose up to five checkboxes. When the user chooses one of the radio buttons and a combination of...

I have code that creates a user form with a Combo Box. I would like this form to open after a macro runs with some worksheet formatting. This will allow a user to select from the combo list and input a value into cell D1. I am not sure how to get the code to open the form and when a choice is...

I am working on a macro and almost finished except I can't make one part work. I want to copy the value in cell B1 and copy to all rows in column B. I am trying to have it paste but the problem is the number of rows changes. I have used a code similar to the one below before with sucess but I...

I have a macro that I would like to copy the data in column B down to the last record in column C. The number of rows changes daily. I can get it to copy to a specific number of rows but I am not quite sure how to get it to look at the number of rows in C and only copy B to that number of rows.

I am creating a macro that I need to do delete rows if they begin with the text "f" or "e". I haven't been able to quite this to work right. Also with this same macro I would like to combine amounts in column d if entries in column A and column c are the same. I haven't been able to figure...

When in Excel I am trying to get a third decimal place, which is always a zero to stay in the format of a column. I am saving the file as a .csv to use as an import. The number example is 8010.020. Is there a way to keep this third decimal place. Simply formatting the column doesn't seem to...

I am wondering if there is a way to set up a workbook to allow multiple users to be able to make changes simultaneously. I know you can open as read-only if you open a workbook that someone else is using. I am just wondering if there is a way to set this up because I have a worksheet that is...

Somehow in Excel my column headings have changed from A,B,C, etc. to 1,2,3. I have tried to figure out why this is but can't find how to change it back to the standard headings of A,B,C. Does anyone know how this gets changed and how to correct it?

I have a column of cells that I am trying to format in Excel and I can't get it to work quite right. The row contains data like the following, 8010.33. My problem is when the data is 8010.02, Excel contains 8010.2 Does anyone know how I can format this column so that if it is a single digit...

I have a user form in a Word template that I would like to add a message box if some of the data is not filled in. The form has a series of text and combo boxes along with radio buttons. I would like to have a message box open if some of the text boxes do not have data in them. I am assuming...

Is there a way to set up word wrap in Visual Basic for Applications editor so when you have a long code it all appears on the monitor. I can't seem to find an option for it. I have been able to do it using Visual Studio.

I have a Word template memo where the user enters name, address, etc. in the first section. The second section has five different paragraphs that may applicable. Only one will apply to each letter, so I would like something like a drop down list that the user could then select the paragraph to...

I am trying to determining if a date occurred in the first or second half of the year using Excel based on the day and month. The years are all different but they are not pertinent. Does anyone know some type of formula that will return a value that I can determine whether or not the date was...

I am trying to find the difference between two dates in Excel. I can find the number of months but I need the months and days. Basically, I need to see if the difference is greater than 4 months and 15 days. To find the difference in months I am using =month(a2)-month(a1). Does anyone know a...

I have an Excel sheet that has eight rows of data then a blank row, then another eight rows and a blank, etc. for up to 25,000 rows. I am trying to transpose each set of eight rows into eight columns. I tried copying the data then using paste special and transpose and skip blanks but I can't...

I have a spreadsheet that is an exported file from another software. The dates that were exported are in a "different" format. For example the date is exported as 20701 is the date 01/07/2002. Another one is 960226 which is 02/26/1996. Another one looks like 617 which is the date 06/17/2000...

I have two excel spreadsheets that I am trying to combine some of the information from them. One spreadsheet contains and ID# in column A, an Acct# in column B and a $amount in column C. The other spreadsheet has the same ID numbers in column A, row 1 contains the Acct#'s with columns B-X with...