Office Software Forum
- Excel (9,869)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Send data from Raw Data sheet to numerous Specific sheets Closed
Hello, Trying to make a document in whcih my laboratory can track the reagents coming in. I have a source sheet, where all the recieved reagent...
-
Copying data directly to a specific sheet Closed
Hi there! I am trying to create a spreadsheet in which I can enter information on one sheet and it automatically carries across that info to the c...
-
Conditional Formatting Closed
I am trying to set up formatting for five different colums as to when I click on the cell, it will give me a color based on the title. I have the cell...
-
A macro for creating multiple file from a source excel file Closed
My source file containing different codes in column 11 and I require a separate file to be created from this source file by filtering the column 11 by...
-
date format Closed
Hello, i have date format like 20131203 (year month day) i want to change it as 03.12.2013. please suggest Configuration: Windows 7 / Chrome 2...
-
it can not find the files Closed
Hi i installed your program to fix the corupted files the system can not find the files it dont show in the list how to do that???
-
Count overlapping Days Closed
Hello, I'm trying to count the # of days overlapping between 2 different ranges of days. I'm using a max and min formula and tried some if statement...
-
How to insert blank row with variable input in next column Closed
Hello, I want to insert the row based on the input value in next column, for example. A 4 B 3 C 4 D 4 after A there should be 3 rows to be in...
-
A macro to name worksheets based on a list Closed
Hello, btw how to name worksheet without creating new worksheets, i've already have data in each worksheet so i dont need to create a new one.. I ...
-
Microsoft 2007 Closed
Hello, Hi I have xp pro on my computer, when I try to open any saved documents in what ever format in word, excel or publisher it comes up blank ...
-
Compare data between two Excels containing more than 200 columns Closed
Hello, We are in the middle of a production migration and we need to compare two reports that are generated two weeks apart and find the fields th...
-
Macro for blanks Solved/Closed
Hello, Would appreciate help! I have a spreadsheet which I run daily. The number of rows can change each time I run it (ie one day I have 5 rows; t...
-
sum if Solved/Closed
Hello, Pls help me find the formula for below situation I am trying to sum up 4 when a cell in the Column A contains End with XX7. Otherwise it...
-
space bar problem Closed
Hello, my space bar shows dots instead of space in word 2007 Configuration: Windows 7 / Mozilla 11.0
-
Generate ID for cells containing same values Closed
Hello, I am trying to generate the same IDs for cells containing same values and different IDs for cells containing different values I have for e...
-
Copy Selected workbook/worksheet with specific data into another Closed
Hi, I plan to copy selected workbook and sheets listed in the ListBox where it will copy data at cells(52, "R") into another workbook with sheets(...
-
How do I not get the sum of a column when it contains text? Closed
Hello All, I have an excel file in which I am adding the numbers of a column, but sometimes the column I am summing may have text in one of the cells ...
-
Date of birth in words Solved
Hello, How can I enter date of birth in words in Excel?
-
Help with Formula to Find/Remove if same data in another cell Closed
Hello, I am having some trouble determining a formula that would help me with my problem below. I have a large Excel sheet and am hoping you can ...
-
converting macro into function Closed
Hello, How to change the below macro into a function, so that, we could invoke this macro as =image() Sub Picture() Range("A6").Select 'This...
-
Re:Design Mode Coding Closed
Hi there, I have an issue of auto transferring the data of the same category to 2 different sheet in the same folder. Please kindly advise! I need ...
-
Repair corrupt .PST & .OST files Closed
What methods exist to repair corrupt Outlook 2003 .PST & .OST files besides using the scanpst and scanost utilities? An Outlook 2003 user frequentl...
-
conditional statements Closed
I am needing a formula to accomplish the following ... If student age is 21 on September 1st then make the cell green If student age is 21 after S...
-
Get value of last cell in column B from a closed workbook Closed
Oh Dear - back again... Im trying to improve a macro I have been working on. It works as far as it goes, but I realsed that data needed to be input...
-
Re-Occurring Dates with Values Closed
Hello, I am trying to calculate the months, quarters or semi-annual intervals between two dates, but then populate a value (numerical) in the calc...
-
If data exists, copy multiple cells into one cell Closed
Hello, Excel 2010. I have several cells on sheet 1 that may or may not contain text. If they do, I want to copy that data from the group of cells ...
-
Conditional formatting cells A and B based on value in C Closed
Hello, As you can see from picture: I want to fill with red colour cells A and B if value from C is equal with value from A. I want to do this wi...
-
Powerpoint 2003 gives error Closed
Hello friends! I need help. Powerpoint 2003 gives the following error: "Powerpoint can't create the storage required for an inserted or linked obj...
-
unable to open saved outlook .pst file from outlook Closed
i get an error (cannot open .pst is not a program folders file). i tried everything that experts exchange offered. one of the ways was to run scanpst...
-
how to find missing text or values comparing 2 cells Closed
Hello, i have data in 2 columns, for ex: Column A: Bearing, Ball, 1/2 in, Cast Iron Column B: Bearing, Ball, Cast Iron by seeing this exampl...
-
Popup menu with count Closed
Hello, Can you help me with this? I have list of 150 driver's with licence valid upto info in D3:D153. I am trying following things 1. Check if va...
-
Writing a Macro Closed
I am struggling trying to figure out how to move data to a new line by inserting and not copying over other data, plus removing data based on specific...
-
creating a workbook after entering a data in other workbook Closed
Guys , can anyone help me with this;; I need to create a workbook once i type a data in other workbook( say master). the created work book should con...
-
Macro to Copy Column, Open Existing Document, Paste & Save? 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 all...
-
recover corrupted outlook express folders Solved/Closed
I accidentaly deleted some folders in my Inbox Folder. My problem is now, how do I get back the .dbx files without losing any important information? P...
-
transfer data from one sheet to another automatically Solved/Closed
Hello, I would like to populate data on a spreadsheet based on data obtained from another. Is this possible? If so, how can I do this? Example: S...
-
formula with @ in cell Closed
Hello, Could someone please let me know if there is a formula to get a total if row 4, column D is 8 @ 2000 and row 6, column D is 9 @ 2000. The...
-
VBA Code for Bank Recos Closed
Hi All, Greetings I am looking for a VBA code for bank recons where I want to reconcile cash & bank statements, where i want to move match items...
-
Delivery Status Notification (Failure)? Closed
Hello, I replied to some emails today and i keep on getting emails from ***@*** saying : This is an automatically generated Delivery Status Notif...
-
copying cells macro Closed
Hello, I have a number of workbooks and worksheets that i have data on but i have only two cells on theses worksheets and want to put all this data ...
-
Joining and deleteing lines Closed
Hi, I wonder if you can help me, I've got some software the produces a table similar to the below where if the user has more than one car, it puts ...
-
duplicate excel lists Closed
I have two excel lists, one containing 10,000 members and one containing 12,000 members. How do I formulate a list of those members who only appear ...
-
Can't recover my email account Closed
Hello all. I have been having trouble with a old email account I used to game with on the xbox 360. I want to try again to recover my email because I'...
-
adding cells across multiple sheets Closed
Hello, Trying to add same cell across different sheets..after a bunch of tries with formulas..finally got it but it wont add cuz it has a text..how ...
-
A macro that creates a sheet as I add names Closed
Hello, I am an absolute nocie when in comes to VBA and wondered if anyone can help. I am trying to create a macro that will copy a new name entered...
-
Please help resolve this Closed
Hello, =IF(B1=Sheet2!A1,C1=Sheet2!B1) i have a cell in sheet 1 need to write the price from sheet 2 when I put a certain text in sheet 1 Conf...
-
Macro Help - Copy/paste into a new workbook. Closed
Hello, I have a spreadsheet that has over 570,000 rows, starting a column A and ending at column S. I need to be able to break my spreadsheet down...
-
Can Not Open Any Documents in Word Closed
Hello, I would like to open files and not able to open in MS Word Configuration: Windows / Chrome 41.0.2272.118
-
Comparing two columns Closed
Hello, I have two columns of costs that I need to compare by a table with colors signifying one cost was higher, lower, or equal to. MAP cost i...
-
new formula Closed
Hello, Is there a formula to get a total if row 4, column D is 8 @ 2000 and row 6, column D is 9 @ 2000. The total should equal 17. I want...
