Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
multiple processors for Excel Closed
I work with very large spreadsheets in Excel on a Mac and I often have to wait for Excel to execute things like sort and fill. I'm hoping too solve...
-
auto generate invoice number Save and Clear Closed
I'm new to this site. I'm using excel 2013, I want a macro to auto generate invoice number, at the same time when I save it should copy and clear th...
-
If... Then Closed
Greetings all, I hope I can explain this correctly as this is my first time asking questions on a public forum. All me to set the stage. A = ...
-
How to retrieve a person's seat number from microsoft outlook Closed
Hi All, I am trying to get details of a employee from office communicator using VBA. I am able to retrieve every detail of a person except "Seat Nu...
-
Format fill colour based on another cell Solved/Closed
Hi I would like to format my excel page so that the rows alternate between two fill colors based on whether two cells are equal or not. Here is an ex...
-
calculating text to result certain text result Closed
hi, if I enter S into cells a1 & b1 & c1 I need cell D1 to result 'CO'. if either cells a1,b1 or c1 has NYS entered into either cell or all 3 cells I ...
-
Search values in one workbook and paste into another workbook Closed
I have to paste monthly figures from one Excel workbook to another workbook I want to write a code that search for the departments name within the...
-
Transfer cell data from one workbook to another workbook Solved/Closed
I am using two workbooks to track account spending for quarterly reporting. Workbook 1: Day Expenses Workbook 2: Monthly Expenses WB1: I have fo...
-
Question about my if statement Closed
Hello, I have an excel file with portions of addresses and i want to take the city state and zip code and put it in a separate cell. For that i u...
-
Date format change in excel Solved/Closed
Hi, I have an excel worksheet with a date column in the format m/d/yyyy h:mm:ss AM/PM. How can I change it to the format d/m/yyyy h:mm? I tried the '...
-
Extract data from one workbook and paste into another workbook Closed
We receive a workbook with various different sheets every month. We need to copy data from the workbook we receive into the workbook we use. We have ...
-
Macro to cut data from multiple worksheets Closed
Hi guys need help with a macro Scenario Have 3 WorkSheets (TEB,CEB,LTE) in a workbook called Cases All worksheets contain same Column Names I wan...
-
Applying conditional formatting to Rows that vary Closed
I need to have AA turn red when the date is out of window of AB and AC. I have dates in column AB and AC the dates are all different in each row. I...
-
Date formate Closed
i have 2 date formate example 06/11/2004 07-01-2004 and i want 1 formate and i useing this function =text(CellAddress,"DD/MM/YY") and text(...
-
numerical value is range of cells has a text value Closed
Hi guys, This is for a holiday rota. if any sell has a 'h' in it I would like to total up the h's in a cell at the end as a numerical value of how ...
-
Macro to create a sheet and copy rows into that newsheet Closed
Hi everyone, I have a work book with 3 work sheets. Each work sheet contains 12 similar columns How do I write a macro to create a new sheet (sum...
-
Excel Macro to combine multiple values Closed
Hi All, I am new for Excel Macro. Need to create a macro to get below attached data. InPut - Output - Please help me on this to devel...
-
Sum range if 2 conditions met Closed
Hi, I have arrange of numbers which I would like to sum in a certain cell, only if a column contains certain text and another column contains another ...
-
How to freely download softwares? Closed
Hello, Please help me in downloading IDM, Mavis typing and Adobe reader free of charge. Thank you!
-
Macro to add certain cells to another worksheet based on cell $ Closed
Sorry, I know this has been covered a million times, I've looked up probably 30 different examples that look very similar to my situation for a macro,...
-
Classic Menu for Word 2010 or 2013? Solved/Closed
Can you clarify? Will "Classic Menu for Word" work for Word 2013 or just for 2010? I see both on your download page.
-
IF FUNCTION FOR DATE RANGES Closed
I need to know how to do an if function: If D2 is >= 9/1/2008 and E2 is
-
Formula Help to Add Columns that Contain Text Closed
I want to add the total of Column A (going to be text) and Subtract Column D if there is an "x". How do I do that formula? Anyone able to help? Exa...
-
LibreOffice Calc Closed
How do I turn off the spell check in LibreOffice Calc? Trying to type in Wittenberg, and it keeps changing it to Gutenberg . Went in to Tools, and O...
-
Hi All can you help me with the formula i require below Closed
Im looking for a formula that will look at a number in row b and if that number is 1 will add 1 day from the date in row c and put it in row e, and if...
-
how can rename Multiple Files Once Closed
Dear sir, PLS tell Mehow can rename Multiple Word ,Excel Etc Files Once Regards Santosh
-
Excel - creating reminder pop up based on criteria Closed
Hello, may you please help me in creating a reminder to pop up for every 5 hours once for a cell range having text equal to "pending" I was able t...
-
Using a macro to Copy and paste special values to a new workbook Closed
HI, I have a lot of financial data that is downloaded from a specific program with code. I want to be able to go and select multiple tabs in one workb...
-
Downloading PDF Conversion Closed
I would like to know if it is possible to download and install pdf converter to my laptop. thank you.
-
Help: Return day of the week Solved/Closed
Hello, I have checklist sort of form that I am printing every month to let them sign for task everyday. from C3 - AG3 it is numbered 1-31 and un...
-
Generating Individual Reports From A Master Sheet Closed
Hello everyone, I have a master pay sheet I am working on. I created a macro to create a 'pay summary' breaking down deductions, credits, etc. ...
-
Excel - Repeat rows to a specific number of times Solved/Closed
Hello, Hi Does anybody know how I can repeat rows in a spreadsheet (or into another spreadsheet) by n number of times specified in the cell in...
-
How to copy sheets from one work book to other Closed
Dear Team. My query is Iam having two workbook in d drive as 1.xlsx and 2.xlsx i want to copy two sheets from 1.xlsx and paste in 2.xlsx ...
-
Macro to add down a column Closed
Hello all, I need a macro that will sum numbers down a column until it gets as close to 8 as possible. ex: 1 .5 .5 4 3 .5 3 2 so a ...
-
nested formula with 'or' statement Closed
Hi, I have formula IF(ISBLANK(A3)," ", C3-TODAY()), which works absolutely fine but and i want to include another argument on it so that if value in ...
-
Sumproduct gives me error Closed
Hi, I am using the below formula, but it gives me error. Any ideas why is that? I really should work same as the countif formula but instead it giv...
-
Find Text In one Cell, Add Different In Another Cell Closed
Please be aware, I don't have much hair on my head to begin with and really don't have much to pull out either.. I'm frustrated. I've tried every ...
-
Excel Closed
Hello, I want to transfer a single cell of information (which is a number) from an external excel sheet to another excel sheet. I dont need tables, l...
-
Moving columns based on text Closed
Suppose data is like this: 3 3 OPG 4 5 2 5 3 MCG 0 4 3 0 4 ELG 4 2 4 7 5 CTG 4 2 1 I want a macro ...
-
How to do recursive searches in Excel Closed
Hi, I have two worksheets. I need to be able to traverse a column in the first sheet and for each cell, compare it to a cell in the second sheet. If ...
-
cell auto filled with dots Solved/Closed
Hello, I sow it once but not sure where and can't work out how to do it. Basically, if I write things in excel, I need it to be auto filled with do...
-
tracking 3 columns of scores between 1-10: OSAT, Arrival, Staff Closed
I am excel illiterate so please forgive me... I need to create a formula that will go out and look for a set of initials, take the data associated ...
-
Automatically transfer data from one sheet to another Closed
Hello, I have a workbook in sheet1 details of materials issued to dealer for job work Sheet1 Columns: Dealer name, Date, Challan No, Item, Qty, etc ...
-
How to copy data from one excel table to other Closed
I have two sets of excel tables. The master table has got several columns with heads defined. Similarly, the row heads have also been defined. Now...
-
Compare text cells Closed
Hello, I need to compare text cell and return me column title- row 4 I have made this formulla =IF(B24=N5:N19,N4,IF(B24=O5:O19,O4,IF(B24=P5:P1...
-
error in date formate Closed
find attachment of date format issue .......how resole the error please let me know
-
getting it set up Closed
I get the program open and I start the process to get email to this new laptop and it fails. HELP!!!
-
can not open a PDF by clicking on it anymore Closed
I downloaded this a few months ago. I use PDF files often that I have saved on my PC and within our resource center of the company's software. I can...
-
Help: Macro compare worksheets and generate new with difference. Closed
Hello, I am trying to compare two worksheets Sheet1 and Sheet 2 in the same workbook. And after comparison it will be copied in Sheet3 with the d...
-
VlookUp Problem? Closed
I have 4 Column A,B,C,D A=date B=MarketValue C=Results D=Numbers when i use the vlookup formula in other sheet it not working =vlookup(A2,Shee...
