Excel Forum
-
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, whe...
-
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 Date ...
-
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 autmatic ca...
-
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: ######### x...
-
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 open, i ...
-
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 to sh...
-
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 need ...
-
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 solution/form...
-
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 date. =IF([cell]="","",""&[cell]&" - ...
-
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 example. column...
-
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. Also...
-
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 through...
-
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 fil...
-
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 date...
-
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 infor...
-
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 is is...
-
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 want to...
-
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 formula...
-
Recurring date formula Solved/Closed
Hi 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 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 appear...
-
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-Status...
-
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 (or sh...
-
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 with d...
-
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 way i ...
-
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 funct...
-
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 new ...
-
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 this ...
-
Macros to Insert rows defined in column "X" Closed
Hi, I m new to macros, need your help to create macro per my below requirement... Eg.. Value updated in column "A" is 10 so it should add 10 new...
-
Macro on a pivot Closed
Hi I have been trying to find a macro that copies a cell and pastes into a number of cells beneath it until it reaches another cell that has data, ...
-
macro to insert picture in text box Closed
sir i have names in A1:A5 of customers on sheet1. I created folders named CUSTOMERS ID and SIGNATURES in D:. I scanned images of customers Ids and Sig...
-
Can This be done? Closed
Hello, I have a spreadsheet that I created with the help of ac3 mark. Thank you Again. It works well and now i would like to see if i can add mor...
-
Macro Range Solved/Closed
Hello, I am somewhat inexperienced in the world of macros in excel. I have a looping macro that runs from the bottom and i want it to stop at ...
-
How to tranfer information Solved/Closed
I am wanting to set up a sheet that inputs information on another sheet in excel. The problem is, I want it to list the information from one section o...
-
I am just learning the basics Solved/Closed
Hello All, I am new to this community. I have just started learning Excel and am having a problem with a formula. the community here from what I have...
-
formula help Closed
Hi, I'm looking for a formula for the following scenario: Worksheet 1 Cell A 129622 Worksheet 2 Cell A Cell B Cell C 129622 1,000 35 ...
-
adding a formula Closed
Hello, how do i may be able to get auto deduct formula from a sum method of multi cells ? Thanks
-
Conditional format based on two criteria Closed
Hello, Can someone help me please with a conditional format that would highlight an entire Row in 2010 if Column B on my spreadsheet has any one o...
-
Conditional formatting using a formula Closed
I would greatly appreciate any and all help, please and thank you so much in advance! I am trying to create a conditonal format on a row of cells b...
-
convert numbers to words in excel Closed
Hello, please give me the formula for converting numbers into words not not into currency and it should be like when I type a number such as 400 i...
-
Create a macro Solved/Closed
Hello, Please help me. I am new at macros, and I need to create a macro that will automatically total a column as below: # Name ...
-
Need help with an IF function Solved/Closed
So, I am trying to get this formula to work. The situation is that one of our items have changed names. In the spreadsheet, I am trying to get a f...
-
convert number to word in excel Closed
Hello, i want a number to be converted to word in excel such that if i enter a number as 600 it should show as six zero zero please help me sir ...
-
Excel date problem Solved/Closed
Hi, How can I change the date format from a format such as 22042013 - (this is not a text format). One formula I have been given is: =IF(LEN...
-
about the VBA Closed
Hello, Im Kumar and would like to knoe how to setup the VBA in a snapshots. it would be more thankfull if u provide me the snapshots
-
create a macro Closed
Hello, I am new at macros, and I need to create a macro that will automatically total a column as below: # Name Amount Total 0...
-
Any part of string in cell matches part of string in another Solved/Closed
First post after hours of fruitless googling :-) Working in Excel 2010.. I have merged two data sets and where there are instances of exact dupl...
