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

due date reminder in excel 07 [Solved]

Hello, dear all. I have a "credit list" worksheet having the details like. 1) date 2) invoice number 3) name of beneficiary 4) total amount 5)paid cash 4)discount and 5) net pay in a row ( side by side columns) I will enter these details on a daily basis one below the other on datewise. when I raise an invoice , I will enter all these... Read more

due date reminder in excel 07 [Solved]

Hello, dear all. I have a "credit list" worksheet having the details like. 1) date 2) invoice number 3) name of beneficiary 4) total amount 5)paid cash 4)discount and 5) net pay in a row ( side by side columns) I will enter these details on a daily basis one below the other on datewise. when I raise an invoice , I will enter all these... Read more

Excel: Copy active range to bottom of list [Solved]

Hello, On multiple sheets I have lists of peoples names. When I add a few new names on one sheet, I want a macro to copy-paste these names to the other sheets on the bottom of the list (i.e. the first empty cell). Lets clearify, Sheet 1 has names from A1 till A100. The same goes for sheets 2 till 10. When I enter names in A101 til... Read more

Converting rows of data in notepad to columns [Solved]

Hello, Needing help please. From a pdf data base supplied, I have copied the contents over onto notepad. The data within this notepad contains first name, last name, postal address and a whole host of other non related data. The challenge is that the data exists in "rows", and I need to import into excel in column format-that way I can... Read more

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