Office Software Forum
- Excel (9,869)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
conditional formatting Closed
Hi, I have a problem regarding a sheet i'm trying to format. I want to color an entire row but i get color only in certain cells. The sheet look...
-
formula Closed
Hello, Is there a formula to get a total of all of the Salt in column D. Column B could be a multitude of different commodities, salt, pepper, etc....
-
Macro for deleting everyother six rows starting with row 7. Closed
Hello, I am trying to use the macro function to delete six rows, skip six row, then delete six and so on. Can you help me? Configuration: Windo...
-
MIcrosoft Outlook PST file cannot repair Closed
Experts, I have a user, who has left the company, however the manager of the department needs to view this user's outlook pst file. The pst file i...
-
In Excel Programming Closed
HELLO I have two to four columns, each column number is 100 The program will seek to rebound in the second column of numbers in the first column num...
-
Conditional Formart Closed
Hello, i have like four colums like below Name Age DOB Status AAA 23 XXXX Active BBB 25 xxxx ...
-
Markup area Closed
Hello, How do I remove the Markup area in microsoft word? Configuration: Windows 7 / Chrome 41.0.2272.118
-
input repetetive data Closed
Hello, I have to input 100 + truck weights, number plates, ticket nrs and loading times. I was wondering if any one had an easy to use template ...
-
Macro to copy column to existing workbook and save as Closed
Hello, First of all, I'm essentially a VB novice - I've copied and applied a few very basic scripts, but nothing of this magnitude, so any and a...
-
What cell is my data coming from? Solved/Closed
Oh dear - back again ... :^( After you guys help again with VBA. I'm never going to volunteer to try script-writing again! (at least not without...
-
compare vale of A1 cell with B1 Closed
Hello, I want to know formula for the below problem. I want to compare row A with row B and if part of B contains in A then display that particul...
-
Complicatied find and copy cells to new sheet macro help Closed
Hi I am new to excel macros and trying to sort out a large sporting club file. Basically what I want to do is copy all player information from team "X...
-
Conditional Formatting with Dates Closed
I am trying to fill cells in a column which contain a date that has already passed. I go to 'Conditional Formatting', choose 'Manage Rules' and click...
-
Conditional Formula - What If Closed
I need to create a what if statement for a workbook. Example below... here's what I need, if Column B has the words "Left Blank" I need for it to ...
-
Copy from a workbook from worksheet in Excel to another Closed
I have a worksheet[Fleet] in a workbook and to copy two column on like row ''a'' and ''b'' to another close worksheet [ Normal] on row ''h'' and ''t...
-
set up a count loop Closed
Hello, How do i set up a count loop Configuration: Windows 7 / Chrome 41.0.2272.118
-
About Comments. Closed
Hello, I have a data in A1 cell and certain information of this data is in other sheet. Now i need a pop-up comments when mouse just moves near...
-
Using if Closed
Hello!! I am trying to use IF condition for the below situation Copying data from sheet1 to cell's A sheet 2 if cell's "A" sheet 1 equals date fro...
-
Transferring information from previous spreadsheet Solved/Closed
Hi everyone, I'm a junior doctor from Australia, and I'm trying to use excel to make my ward management a more efficient process! Everyday we get ...
-
Excel- A Macro to copy data from one sheet to another Closed
Hello, Could anyone help me with this. I am trying to write a macro with following criteria. 1. Every week a set of data is entered into she...
-
How to transfer the data from one excel sheet Closed
Hi, I want to transfer the data from one sheet to multiple sheets based on one specific one cell text. e.g. i have customer details for sales and t...
-
How do I resolve file corruption errors in powerpoint 2010? Solved/Closed
Dear All, One of my colleagues is getting an error frequently(attached) in powerpoint 2010 and as a result he keeps losing many slides that he prep...
-
Single Quote - Excel 2007 Solved/Closed
Hi, Does anyone know what the single quotation mark ' means when entered at the beginning of a cell? I notice that the quotation mark does not ...
-
Conditional Formatting based on expiration dates Solved/Closed
Hello, I am trying to figure out how to introduce conditional formatting to a range of cells with date values. I want each cell in the range to b...
-
Cell value based on other cell's conditional format font color Closed
Hello, I have conditional formatting on cell a1 that if it is from a list of text then its font color is blue. in b1 cell i want to write "Blue" i...
-
how to convert date into words Closed
how to convert date into words
-
auto generated file using vba Closed
Hello, i am new to vba ..i want to create file by selecting month of the calendar ..suppose if i selected march from sheet1 ..row and column need ...
-
How to convert OST File to PST file? Closed
Hello, We only have the OST file and no longer the PST file for outlook 2007 application. Can you please send me some easy to use and reliable sugg...
-
Two criteria to check if a date in Excel Solved/Closed
Despite my best efforts going round in circles on a simple problem. Help gratefully accepted.... If say, Cell A1 can have two values - "In" or "Out" ...
-
Find and remove duplicates between two cells multiple times Closed
I have a very long list that is broken into various length sections. Each section starts with the same phrase. I want to select the cells in each se...
-
Transfering row data back-an-fro between sheets with condition Closed
Hello, I am searching for a solution and came across your website; my problem: Sheet 1 is a chronological list of issues listed in a corrective actio...
-
Formula to add big number of day to date in excel sheet Solved/Closed
Dear Please advise me how I can creat formula in excel sheet to help me to calculate due payment day for LC. As example I want to add 120 or 180 day...
-
word search in a cell Closed
Hello, In one cell i have below text: NIPPLE, PIPE: TYPE SEAMLESS, SIZE 1/2 IN, LENGTH 100 MM, CONNECTION TE, MATERIAL CS ASTM A106, RATING...
-
Using the last few characters on a different sheet Solved/Closed
Hi All, Me again - I HATE VBA! it is so simple that I get frutrated when I cant get a simple thing right. Im trying to write a VBA script that n...
-
copy rows from all tabs in the sheet Closed
I have an excel file with several tabs. I want to read a specific column in each tab and if matches a word or string then copy that entire row in a ne...
-
Comparing 2 columns with conditional results Closed
Hello: I am a basic/intermediate excel user and new to this type of forum, but I am hopeful someone will be able to provide me with some help/solution...
-
Date formatting wont change Closed
Hello, I have a date field that show 43036, but in the menu bar it shows the actual date of 3/1/2015. How can I have my data in the cell showing ...
-
convert every 4 rows to columns Closed
Hello, I need to convert every 4 rows to columns I have 1 2 3 4 5 6 7 8 9 and trying to get 1 2 3 4 5 6 7 8 9 ...ect p...
-
How can data automatically go into a calendar created on excel? Closed
Hello, I created a calendar on excel to collect past, present and future data but I wish to run it automatically. I know how to link data from on...
-
excel question Closed
Hello, I am looking for a formula for excel: I have three tabs, how to make one cell automatically return to "1" within the first tab; and the cel...
-
Conditional Formating Closed
I have a spread sheet with 2 columns; In column 1(one) I am tracking Employees. in column 2 (two), I track the employees position. When a position i...
-
VBA cod Solved/Closed
how i send data to you for solve the vba cod create in my excel file.
-
Formulas being lost in second sheet after sort Closed
Hello, If someone could help me with this please, have a number of sheets for pricing a product we produce, so in sheet 1 I place the purchase pri...
-
Data between tabs Closed
Hello, I have a number of sheets for pricing a product we produce, so in sheet 1 I place the purchase price of all the items we buy then sheet 2 I...
-
vlookup won't work Solved/Closed
I am trying to set up a formula in Excel 2013 that says to look at what is in X11, find the title and explanation in a group of cells on another works...
-
Transfering data from one workbook to another Closed
Hello everyone! My problem is based on that I have a workbook no 1 (picture added) where I would like to add data and I would like to transfer adde...
-
adding one day to a date Closed
Hello, I have a spreadsheet that i use for planning truck maintenace, I am trying to work out how to have 2 buttons that i can assign 2 macrows too,...
-
Copy Excel Data present in common location to excel Closed
Just a beginner with macro... no experience at all... Here is my problem... I have some excel sheets placed in a common folder in my local disk. Th...
-
How to copy data from one worksheet to another Closed
Hello, I'm having the following problem, I have made a file with two active worksheets. Now I would like to copy the totals from worksheet1 into...
-
Error message when sending an email to a specific address Closed
Hello, When I send an email to a couple of addresses, from Outlook, I receive the following message: "Delivery to the following recipients was abo...
