Registration date
June 14, 2009
Last seen
March 10, 2016
Contributions
1,862

VBA find column by name and sort [Solved]

Hello, I am trying to make a code that should: - Go to the first worksheet - Find the first column with header "sku" - Sort this column ascending However, I just don't seem to get it right. Error message that I get now = Run-time error "1004". The sort reference is not valid. Any advice is appreciated. Underneath th... Read more

Excel - IF function with multiple words [Solved/Closed]

Hi I'm trying to write a formula to produce a yes/no answer depending on whether the data in a previous cell in the same row contains any of the words I am trying to match. Ie. I want the formula cell to read "Yes" if Cell B4 contains the words "Apple" or "Banana" or "Carrot", or "No" if it doesn't contain any of those words. I a... Read more

Excel "IF" function w/ date in test cell [Solved/Closed]

Hello, I am trying to use the IF function with a date in the logic test cell; If the logice test cell has a date then I want the word "DONE" to sho, if it doesn't then I want it to calculate the difference between two cells that are populated with dates. The formula that I have been trying to get to work is shown below...any thoughts ... Read more

Copy row and insert n times [Solved/Closed]

Hello, I have an example below, I'd like to take the first row, copy it "n" number of times, then take the next row copy it the same "n" number of times, till the end of the rows. Sample ColA ColB ColC TextA TextA1 TextA2 TextB TextB1 TextB2 TextC TextC1 TextC2 Results (for example... Read more

If a cell contains any text then add a value [Solved]

I hope someone can help me with this...I've done this before but can't remember how. I have a list of names (for an attendees list) and I need to show an extended total for each person and the number of guests they will bring. Here's the layout... B2 is the person's name C2 is the number of guests they will bring D2 is the tota... Read more

Lookup across whole workbook (muliple sheets) [Solved]

Hello, I would need your help with my problem in MS Excel. Here is the description: 1. I have an Excel workbook containing multiple sheets (ca. 15-20) 2. Each of the sheets contains several records of the products identified by unique pr. number/code 3. So, I need to find a function or macro which will do following: if I enter sel... Read more

Running a macro in different cells [Solved]

Hello, I have a question. I recorded a macro to average a series of columns, highlight the averages row in a bold color. I would now like to run the macro in seven different rows so I don't have to keep copying and pasting the formula etc. But everytime I run the macro, it runs it in the same row where I created the maco (i.e., row 32, i... Read more

Comparing data between two excel sheets [Solved/Closed]

Hello, I have two excel sheets with the same columns. Essentially Name, Email, Phone. One sheet is the 'original" data and the other is the "updated" data which may contain additions or deletions of names, and/or changes in email address, phone, etc. How do I generate a list of "changes" - essentially differences in sheet 2 com... Read more

Unable to change date format in Excel [Solved/Closed]

Hello, I have an excel worksheet with a date column, the format is set to dd-mmm-yyyy but the dates in the columns display as mm/dd/yyyy. If I double click in each individual cell and then move out of that cell the format changes and the dates appear correct. I have 24854 dates I need to change, I can't take time to double click in eac... Read more

Need to extract specific XML data from a cell in excel

Hi, I have the following data in cell A1 of an excel sheet: 39211000011200100100019 i would like to extract the value from this and print it on the adjacent cell. i would like 00019 printed on the cell B1. any help would be much appreciated. regards, Alvin Read more

get a percentage in microsoft excel [Solved/Closed]

Hello, I am trying to get 10% of a number in another cell. rather than doing it in my head, I was hoping someone would know the formula. If you do, could you please let me know, Kind reguards, Theocupent

Convert the fraction to Month and Year

Hello, I need to convert 05/10 to Month and then Year. i.e., for Example it should come as May 2010. Please give an idea to get the above output in the Excel 2003. Configuration: Windows XP / Internet Explorer 7.0

Excel - IF function with multiple words [Solved/Closed]

Hi I'm trying to write a formula to produce a yes/no answer depending on whether the data in a previous cell in the same row contains any of the words I am trying to match. Ie. I want the formula cell to read "Yes" if Cell B4 contains the words "Apple" or "Banana" or "Carrot", or "No" if it doesn't contain any of those words. I a... Read more

update dates in excel spreadsheet each year [Solved]

Hello, i have 4 spreadsheets linked together which i use to keep track of my accounts. all 4 spreadsheets are in one folder. On each spreadsheet i have the date mon to sun with a weekly total underneath for each month running down column A. My dilema is that each year i have to copy all the floder, wipe all the data leaving the ... Read more

merge 3 general cells to one date cell

Hello, I made a mistake formatting my HUGE tour schedule. I thought I was so smart using 3 cells for dates a1= 10 (for 2010), a2= month 1-12, and a3= day (1-31). Now that I've found the date calculator function I would like to simply combine cells 1/2/3 to make a date cell 1/31/2010 (I have about 900 dates!). Can anyone tell me an eas... Read more

searching names in drop down list in excel 07 [Solved]

Hello, I have placed a drop down listbox in my excel 2007 work sheet and selected the range of names which are in the same sheet. In the list I have as many as 600 names. My question is this: how to fast search through the names ? I mean, just like our cell phone contact name search, by pressing , say , p I must be able to go to name... Read more

excel macro formula to sum column [Closed]

Hello, I need help with a macro please. I need a code to sum up Column E from line 3 to the end of the data. The formula needs to be in the cell row at the ended of the column but the problem is the end row various from report to report. The formula also need to substract the last line from the sum. The other consideration in the code... Read more

Highlight unique or duplicate on 2 sheets [Solved]

Hello, I have a Excel file of 2 worksheets and have a list of Usernames on column B of both worksheets. Few of the usernames appear on both sheets and I am trying to highlight them with some color. I can do it using "Conditional Formating" (highlight unique/duplicate if both columns are on same worksheet. Is there a way to do it if i... Read more

Excel Conditional Cell Formatting

Hello, I need an MS Office Excel 2007 formula. I want to fill multiple cells in a row with color IF one particular cell in the row is divisible by 5. The particular cell with the number in it contains a formula (example: =$C$1-C65) Thanks for any help you can give. Nancy Read more