Office Software Forum
- Excel (9,851)
- Open Office (117)
- Outlook (652)
- PDF (334)
- PowerPoint (185)
- Word (2,189)
-
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...
-
Conditional format based on another cell on another page Closed
I have two databases. One is a list of parents and the other a list of students. The parents each have a unique 'Parent ID.' I need to evaluate each ...
-
Column change where pull values from according to the month Closed
Hi All, Please let me know if the below are possible and how: I have a workbook with multiple sheets named "SUMMARY" (Master sheet), "MAR", "APR...
-
Creating a Macro to Find Text and Then Merge Cells Solved/Closed
Hi- I need some help with creating a macro. I haven't been able to get it to record correctly and I am completely illiterate in Visual Basic. ...
-
convert numeric date into words Closed
hi want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April 2010 or Twenty Tw...
-
Macro in Excel to copy and paste selected from one Sheet Closed
Hi I have an excel with couple of sheets. 1st sheet contains summarized data. Now I want to scatter the summarized data and copy the same data in t...
-
EDATE if then scenario Closed
I have a date column of original date of action. I have another column that has a formula to give me 6 months from that date (which is when additiona...
-
Microsoft Word 2007 default language problems Closed
Hello, Noticed today the word 2007 spell check lanuage will not change to English (any English Version). It only wants to go to Spanish and Portuges...
-
insert one new copy row Closed
i need help pleas :) i want to insert one new row every time Verifies the condition and also copy some cells from last row like if(y3="y",...
-
automatically insert the current date into one cell when "x" is Closed
I'm trying to create and IF formula. What I want it to do it automatically insert the current date into one cell when "x" is typed into a different ce...
-
To get a price from price list while making a purchase order Closed
Hi,I would like to know how to create a macro code I have two files one named Price list and other Purchase Order. Actually I wanted like this ,the pr...
-
Grading on excel Closed
i need some help to grade marks from a b c d e on excel 2010
-
Creating automated Attendance Closed
Herewith enclosed Attendance sheet which I am trying to figure out. Here are my few queries as of now: 1. Firstly I want to put restriction on RH (...
-
Use Conditional Formatting To Copy Entire Rows Closed
Hello, My name is Brandon I'm new to the forum and am thrilled to have found a community that specializes in excel. The current issue I'm having i...
-
To get a price from the price list while making a purchase order Closed
Hi,I would like to know how to reate a macro code I have two files one named Price list and other Purchase Order. Actually I wanted like this ,the pri...
-
Pivot Table Setup Closed
I need some simple pivot table help to get me past a stumbling point. The database I am working off of has the following columns. A: INVDATE B...
-
page set up Closed
Hi.. In Excel , I need to have at last paper from the sheet a different ( first row ) not matching the (repeated rows at the top of each paper from...
-
Macro to copy specific data from multi sheets based on criteria Closed
Hi, I am trying to copy specific cells from different sheets to master sheet under the following criteria: * Master sheet should be generated when...
-
Bold Text Solved/Closed
Hello Sir, I required the macro to bold some specific text in cell like: Below mentioned formula is written in cell ="We are enclosing herew...
-
Broken brain! Can you help? Closed
Hi guys, As a relative newbie to excel I've been trying to solve a referencing problem for days and I'd be hugely grateful to anyone who can solve ...
-
Auto-copy rows based on their values to a new sheet Closed
Hello, This is my first time in a forum like this but I have already browsed through a lot of sites regarding how to do this. I have been using ...
-
Finding duplicate value and display the duplicate cell address Closed
Hi, I'm a new member. I've data of different roads with their distance data in multiple sheets ie., different sheets for different years. I want chec...
-
VBA CODE FOR Sub Total, 13% HST, G/Total, Adv Paid and Balance ? Closed
Hi Friends, I'm working on a VBA excel project and need help to write a Code, which can calculate the Amounts (as described Below) and Show on the Us...
-
Column namewise data copying from multiple sheets and work books Closed
Dear Friends I need to copy data from mutiple sheets and work books according to column heading wise. In my master Excel sheet, I have 48 Column...
-
need vba Code to Transfer Data from Sheet3 to Row1 of Sheet2? Solved/Closed
Hi dears, I need a VBA Code which can transfer the LAST ROW's (ie 15 or 29 or may be any other) Data of Sheet 3 to ROW 2 of Sheet 2 . Reason to Trans...
-
Purchase Microsoft Word 2010 Closed
Hi, This is my first question to Kioskea.net; am happy to be a part of this. My question: I want to purchase Microsoft Word 2010 online and install i...
-
excel program Closed
Hello, im eve, im just want to ask if how can i make a formula which column D automatic less when column C change. then after all the value of col...
-
can't open MS office 7 Closed
I can not open the MS office . I have windows 7 . it says ( there was a problem sending the command to the program )
-
Can't save PDF file in readable format Closed
Hi, I cannot download a file and save it in a readble format. It downloads from email and, when I open it, it is fine. If I then open it in the d...
-
preguntas en excel en computacion Closed
digame cual la funcion que de daba la fecha y hora en excel
-
Want to create macro...help required Closed
Dear All, I have two sheet one containing first sheet containig below columns 1)customer name 2)customer type 3)customer tel no. 4)customer res...
-
Copy & Paste in Excel using macros Closed
Dear Friends, I have a interesting query about the heading. I have a master excel file, in which I want to copy the content of the another Excel f...
-
Copying rows from one master to sheet to different worksheets Closed
I have a group of 16 people. I am trying to take a large spreadsheet, 30 columns and eventually several hundred rows and trying to automatically copy...
