Office Software Forum
- Excel (9,733)
- Open Office (113)
- Outlook (635)
- PDF (334)
- PowerPoint (174)
- Word (2,183)
-
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...
-
Deleting rows with no data (in a range) [Closed]
Hello, I have a sheet that I have been working on..all working fine, however I have one last bit that I cant seem to get right. Worksheet - "Fr...
-
Total and Avg. data from another worksheet based on day of week [Closed]
I am doing tracking for my employer. I have a sheet (Sheet 1) that I input data for every day of that month(i.e. 1st-31st) in the adjacent column I li...
-
ADOBE ACROBAT free download [Closed]
How can I get a free download?
-
Insert date from one sheet to another Sheet ? [Closed]
Dear Sir I have Two Sheets one Name is FirmDate and Other Event i want i put one date in Event and 260 Dates FirmDate uper of Select date in i...
-
Excel how to question [Closed]
Hello, I did not intend to offend anyone when i originally posted this message, I am new to forums and was not aware of the policy. I do apologize. ...
-
Macro to rearrange data [Closed]
I would like to enter a data as shown in the sheet 1 pic below and want it to be stored as shown in sheet 2. Can someone share how to code using macr...
-
Conditional Formatting Special [Closed]
Hi, I'm trying to create a conditional formatting to highlight the column if the cell in row 4 ="S". I can do it one column at the time, like the ru...
-
if formula [Closed]
hi all Please help me with this. Any help will be appreciated. Thanks in advance. if date in column A which refers to a text in column B..(A1 date...
-
retrieved data automatically put into separate sheets as per th [Closed]
I have created a registration form using the survey form offered in skydrive excel. I would like to have the retrieved data automatically put into sep...
-
auto select print area and prints [Closed]
can anybody explain the Macro for auto select print area and print with a Print button in any cell i've a sheet with receipt. and i want to print r...
-
How to delete strings of words from a range of cells [Solved/Closed]
I have a list of website for which some start with www. and others start with http://. I have been trying to remove the "http://" from all the cells a...
-
Need Formula for automatic date update in same cell [Solved/Closed]
Hi all, I was wondering if anyone knew of a formula that would allow excel to change a date in a cell automatically once a certain date had passed?...
-
IF FORMULA [Closed]
What is the mistake in this formula ?? =IF((D10>(B10/2))&((F10)
-
How to show/hide excel worksheet using UserForm [Closed]
Hello, I have prepared one user form and given option button & submit button. I have 4 worksheet. My queries is.... 1. If I select Option 1...
-
using sheets in excel [Closed]
Hi, I am using excel 2007 and have a product database in sheet 1 with multiple columns. I want to take selected columns from this product datab...
-
pdf file compress [Closed]
Dear Sir, here one pdf file containing mark sheet of a student. the file size is 757 kb. the document is to be upload on a software which is showin...
-
Changing cell background color based on another cells background [Closed]
Hi guys. Quick question, is there anyway to change a cell background color based on another cell background being a particular color? I have a r...
-
match formula in excel [Closed]
to match data in one column to another and result from another column.
-
hiding formula [Closed]
Hello, Can you please guide me how to hide / protect formula from other users in an excel? Configuration: Windows XP / Internet Explorer 6.0
-
Excel Macro to search for specific cell and subtract value [Closed]
Good evening guys, My first question here. I'm being beaten by an Excel Macro, I've done some before but this appears to be beyond me. I'm tryin...
-
Wanted to insert column in excel sheet using macro. [Closed]
Sub test() Dim j As Integer, k As Integer j = Range("B1").End(xlToRight).Column 'j is the last column For k = j To 2 Step -1 Range(Cells(1, k), C...
-
Publisher [Closed]
Hi, I just downloaded a free publisher version from your site, but I need a PRODUCT KEY to finish the installation in my computer. Where do I get it i...
-
Excel conditional formatting [Closed]
I have a worksheet that contains a row of payments per month....I want to include in a separate cell the amount of payments that are over $60 per mont...
-
Macro to move rows to a new location [Closed]
Hi, I was hoping for a macro that if in column "C" of an excel spreadsheet it has the number 8 or 9, the whole row gets moved 5 spaces below the the l...
