Excel Forum
-
If Function [Closed]
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 [Closed]
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)....
-
IF x then VLookup and sum, IF Y then VLookup and sum [Closed]
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...
-
Conditional Formatting [Closed]
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...
-
how to auto generate excell sheets based on set of values? [Closed]
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...
-
Condintional Formatting for Dates [Closed]
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...
-
converting numbers into words [Closed]
Please advice that how can i convert numbers into words. Please send solved formula and its related tips.
-
Managing Rows and Colums [Closed]
I have a excel with 9579 rows, data is currently sorted like so: First Name, Last Name, Company, First Name, Last Name, Company etc in rows I...
-
Excel VBA Image Question [Closed]
I am using the below macro to insert a picture into a worksheet. Everything works perfectly until I try to send the document to another person....
-
Link between Workbooks [Closed]
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...
-
Run a Macro when value is... [Closed]
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...
-
date and text functions [Closed]
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...
-
Code for the below scenario - excel vba [Closed]
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...
-
copy complete sheet in excel with condition of a word [Closed]
i want to copy a complete sheet in excel, but only the data with specific word in one of the columns. for example...
-
Copy multiple charts to multiple worksheets [Solved/Closed]
Hi I have a challenge for which I cannot correctly conceptualize a workable solution so I am hoping someone here can share their thoughts on...
-
How to increment numbers automatically in excel using macro [Closed]
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...
-
macro to email a list of transaction in form of statement [Closed]
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...
-
Array lookup [Closed]
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...
-
Excel Macro: Rename all Worksheets [Solved/Closed]
So, 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)...
-
Conditional Formatting [Closed]
Dear Sir, I am working as to follow the shipments being received.When the date expires the cell will show Red in E1 and when in active, in Green,...
-
Excel macro error [Closed]
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...
-
time formulla use in excell [Closed]
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...
-
Excel macro create new sheet [Closed]
Hello everyone! I work with large .txt files and I started to do a project for myself, but I have some trouble. My .txt-s seen:...
-
Excel File is restrict to use the Internet and Taskbar [Closed]
Hello Sir, Good Day i have a small doubt that is, is it possible to restrict the user to use the hole system when a particular excel is...
-
formula to show a value in a cell if another cell has a value [Closed]
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...
-
Changing the format of a cell based on another cell with text [Closed]
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...
-
How to get Numeric value in to Text? [Closed]
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...
-
Excel Formula output text which includes date [Closed]
Hello, My problem is that I would like the cells that are included in my text to return in the format of a...
-
Excel Macros [Closed]
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...
-
V lookup [Closed]
Hai am joseph ,Please send how to use Vlookup formulas in excel, Your website is very useful for me & this is excellent .
-
Need help to create macro, which will run the following formula [Closed]
Hi, Am again coming up with a problem. Need help to create macro, which will run the following formula in col L till end of data in Col A....
-
insert into multiple tables with one SQL statement through php [Closed]
im sorry if this question has already be asked..but i need you help guys..is it possible to insert into multiple tables with one SQL statement...
-
Excel Macro help, hiding columns [Solved/Closed]
So 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 [Closed]
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...
-
need full row if coulam has figures [Closed]
Can anyone help me plz . I need full row Seprately in second sheet if coulam has figures in cells
-
Excel IF formula [Closed]
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...
-
Create a macro [Closed]
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...
-
Need help to create an excel macro (Combine columns) [Solved/Closed]
Hello, 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 ...
-
Matching First and second names with ID numbers [Closed]
Hi I am new but really need help. I need to match a list of names with there ID number. The list of names is small only about 200 but the ID...
-
add two type mix font in one cell in excel 2003 [Solved/Closed]
hallo 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...
-
Finding missing data in column [Closed]
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...
-
Recurring date formula [Solved/Closed]
Hi All I have the following formula in my...
-
cant format date in excell [Solved/Closed]
Hi, 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...
-
Lookup same Entry A1 in 2 worksheet & return B1 from 2nd w/sheet [Solved/Closed]
Hi, I have 2 worksheets. "Master" = Sheet 1 "Status" = Sheet 2 In "Master" Worksheet there are 3 columns, A1-User ID, B1-Username, C1...
-
Conditional format to shade rows if value or date is found? [Closed]
Hello, I am new to conditional formatting and trying to create a few function that will work in Excel 2010. First I am trying to grey out...
-
indirect sum with reference to range on other sheet [Closed]
Hello, I have a workbook with 2 sheets Weekoverzicht and Grafieken The sheet weekoverzicht is populated by a macro. The macro starts...
-
filling in data [Closed]
hi, i have the following query for my work. What i have to do everyday is to manually amend the bolded data and it is tedious. is there any...
-
Trouble with IF/OR function in Excel [Closed]
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...
-
Macro to create new excel when last row is filled [Closed]
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...
-
Copy and paste range of cells in Xcel [Closed]
I would like to copy an paste a range of cells (A1 - A15 )in Xcel to the same row and be given the option to specify the amount of iterations of...
