The discussions
Excel formula to count cell colour and display sum in another
I have had a look through the other questions and responses, but they don't really help. Using Office 2010, I would like to apply a formula to a range...
Due date reminder in excel 07
SolvedHello, 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 c...
If/then relating to a legend
This must be easier than I'm thinking it. I have a set of data I collect every month that I drop into an excel. It's in a list. I take that list an...
How copy a particular text from one column of sheet to another
Hello, how to copy a particular text from one column of sheet to another sheet. For example i have a text in cells of a column in sheet1 i a...
How to sort using vba
Hello, i have a table with 1 230 450 1 301 2 230 450 2 340 7 230 450 7 350 65 230 450 301 501 67 230 450 340 502 71 230 450 350 546 129 2...
Date formatting
I WONT DATE FORMAT (dd/mm/yy) BUT IN MY EXCEL IT SHOWS (mm/dd/yyyy) IN FORMULA BAR. PLEASE HELP ME. I HAVE SO MANY WORK WITH THIS DATE.
Ms excel, lookup word from a cell
SolvedA B C 1 C287198 MARIQ BLDG MATERIAL TRDG C287785 C287785 2 C2...
Excel formula
SolvedI have a blank excel invoice that I want to be able to type the Item number on it and have it populate the vital information on it like the item name,...
We loop-up
How to operate we loop-up programme in excel file
Need help please: excel click timer to time each work/task
SolvedHi Excel Pros, This is my first time to join the excel forums and have seen how helpful you guys are here. I need to come up with a visual basic...
Excel
Hi i need help, i have 2 cells with data in it, for example A1 = AX14587Z4 and E1 = AX14587Z3, i want to compare (match) these to cells to see of the ...
How to extract data from one excel file to another
How do I extract data from one excel file to create a report in another excel file template? The input file has various data fields. I need to extr...
If function
What is the formula to get a return value of Y in column x, by looking at the data in columns a,b,c,d,e,f,g to see if they indicate y.
Need to move 2 columns from excel to notepad
I'm in need of some help here. I have an Excel (actually Open Office) spreadsheet with two columns, A and B. There are 500 rows (sets of data). Not su...
If x then vlookup and sum, if y then vlookup and sum
Hi guys, This is my first post here so I hope I'm doing it right and that someone might help me out. I'm working on a spreadsheet where I inser...
Conditional formatting
I have list of numbers like 4J0249 4HE304 44S305 406305 4B9308 4KI308 here 3 is the last digit of the year and 04 is the week of the year ...
How to auto generate excell sheets based on set of values?
HI, I have a sheet with one set of values as height, width and quantity which work on formula. I have 10 set of values, but now i am copy pasting ...
Condintional formatting for dates
I am working on a spreedsheet to track mulitple people and the dates they signed a wavier. Everyone has different dates they signed. I would like to...
Converting numbers into words
Please advice that how can i convert numbers into words. Please send solved formula and its related tips.
Link between workbooks
New to the forum, hope someone can help! Let me know if I need to clarify my question and thanks in advance. When using formulas to link one workb...
Run a macro when value is...
Hello! I have been trying to run a Macro within a worksheet. Running the macro depends on the value of a cell, it can be 6 or 4 (Changes depending on ...
Date and text functions
Hi, I am trying to find a function which will return the following: If the cell date falls in the previous month of the today date cell and matc...
Code for the below scenario - excel vba
Good Morning/Evening , I need help in coding the below scenario. I have to code in excel vba and have requirement to look for 2 rows . 1st row ha...
Copy complete sheet in excel with condition of a word
i want to copy a complete sheet in excel, but only the data with specific word in one of the columns. for example : number name rate 1 dan 90 2 d...
Copy multiple charts to multiple worksheets
SolvedHi I have a challenge for which I cannot correctly conceptualize a workable solution so I am hoping someone here can share their thoughts on it. ...
How to increment numbers automatically in excel using macro
Hi, I have a column A1 which has values like Tc001 and B1 and Tc002 > I just want to increment only the numbers. How can i achieve it using macros? ...
Macro to email a list of transaction in form of statement
Hi Excel Pros, I'm only a rookie when it comes to VBA excel - I have been pulling customer data via an sql link into a spreadsheet - the data for...
Array lookup
Hello, I was wondring if there was a formula to do this in excel. I have the data in two columns, col a and col b What I want excel to check first i...
Excel macro: rename all worksheets
SolvedSo, I'm trying to figure out a way to rename all the worksheets in a workbook. the first worksheet would be "1" (without the quotation marks) and c...
Excel macro error
I recently tried this macro to make a cell in excel blink but it gives me an error. Our of range error 9 This is the macro Dim NextTime As Date ...
Time formulla use in excell
i use excell 2007 i want to use time formula in excel example for timeshit i enterd my company 7:00 am and i exit my company 23:00pm its autmatic ca...
Formula to show a value in a cell if another cell has a value
Hi ............ Sheet 1 - shows a value of "Y" in A5 Sheet 1 - shows a date value in A1 Sheet 2 - A1 destination cell "Sheet 2 A1" needs to sh...
Changing the format of a cell based on another cell with text
Hi There. I've spent about 4 hours trying to work out the formula or what I'm doing wrong to no avail, please help me before I lose my mind. I need ...
How to get numeric value in to text?
Example: In Excel sheet Cell A1 has 125 numeric value. So I want to convert this into Cell B2 as One Two Five. PLease give the solution/form...
Excel formula output text which includes date
Hello, My problem is that I would like the cells that are included in my text to return in the format of a date. =IF([cell]="","",""&[cell]&" - ...
Excel macros
Hi, I need a code for checking 2 columns with another set of two columns and display the corresponding 3rd column. Let me put in example. column...
V lookup
Hai am joseph ,Please send how to use Vlookup formulas in excel, Your website is very useful for me & this is excellent .
Excel macro help, hiding columns
SolvedSo I'm trying to figure out an Excel macro that would hide row A-K on every worksheet in a workbook. Thanks for any help
Macro to export systematically to master spreadsheet
Hi Guys, I'm quite new to excel macros, a little help would be much appreciated! I am stuck on this problem: every quarter we receive an excel fil...
Need full row if coulam has figures
Can anyone help me plz . I need full row Seprately in second sheet if coulam has figures in cells
Excel if formula
Haven't used Excel in quite some time so this is pretty beginner. I just want to make a formula that turns a cell a different color based on the date...
Create a macro
Hello, Please help. I am hoping that someone will be kind enough to adapt this macro that I can run each month that will return the following infor...
Need help to create an excel macro (combine columns)
SolvedHello, Inputs Col A and Col B ( all data ranges are variable), need out put in C Col. (MACRO), I not good at vba/e , kindly help. Col A ...
Add two type mix font in one cell in excel 2003
Solvedhallo i have a excel 2003 userform with textbox . I have problem in my data base . I have 2 type font in my data like DevLys 010 and arial. I want to...
Finding missing data in column
Hello, I have two columns of data column A and column B. There is data in Column B that does not exist in Column A. I am trying to use a formula...
Recurring date formula
SolvedHi All I have the following formula in my worksheet =IF($AA$2=2,B8+28,IF($AA$2=1,B8+7,IF($AA$2=3,EDATE(B8,1),IF($AA$2=7,EDATE(B8,12),IF($AA$2=4,...
Cant format date in excell
SolvedHi, When I enter the dates as number with out forward slashes, and format them by right clicking on format cells and choosing date the date appear...
Lookup same entry a1 in 2 worksheet & return b1 from 2nd w/sheet
SolvedHi, I have 2 worksheets. "Master" = Sheet 1 "Status" = Sheet 2 In "Master" Worksheet there are 3 columns, A1-User ID, B1-Username, C1-Status...
Trouble with if/or function in excel
Hello all! I'm hoping you can help me with a problem I'm having. For reference, I have Excel 2008. My goal is to write an IF/OR function. The funct...
Macro to create new excel when last row is filled
Hi, The data will be automatically filled in my excel sheet and it will be more than 1500 rows. now i want a macro that automatically create a new ...
