Office Software Forum
- Excel (9,851)
- Open Office (117)
- Outlook (652)
- PDF (334)
- PowerPoint (185)
- Word (2,189)
-
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 year ...
-
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 pasting ...
-
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 like to...
-
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 wish...
-
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. When a...
-
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 workb...
-
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 on ...
-
error ox800ccc79 Solved/Closed
Hello, This is driving me nuts... I can recieve mail but not send please help Outlook Express Configuration: Windows XP / Internet Exp...
-
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 matc...
-
not able to find emails after dragging from pst to inbox Closed
Hello, Hi everyone hope that someone can help me out Here is the situation: I have 2 PCs: PC_A and PC_B. Same domain user, same email account f...
-
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 row ha...
-
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 : number name rate 1 dan 90 2 d...
-
Cant find emails after moving pst Closed
Hello, Here is the situation: I have 2 PCs: PC_A and PC_B. Same domain user, same email account from exchange on both PCs. So this user had a pst ...
-
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 it. ...
-
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 macros? ...
-
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 for...
-
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 first i...
-
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) and c...
-
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...
-
window software Closed
how to install window software on my windows7 basic
-
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...
-
microsoft publisher - product key Closed
Hi I just downloaded Microsoft Publisher and now I need the Product Key to open it. What do I do?
-
Kies -- step one Closed
I'm pretty dumb, never used Kies before except on initial installation to get my Samsun SII up and running. I have Outlook and I bought CompanionLink...
-
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
-
my outlook 2007 gmail working for mail send and received but not Closed
Hi, my outlook 2007 gmail working for mail send and received but not get my previous send items in outlook2007. kindly provide solution Thanks
-
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...
-
configuring microsoft outlook for yahoo mail Closed
Hi, Can someone give me the step by step process of configuring outlook with yahoo mail? Thanks
-
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...