The discussions
If formula
What is the mistake in this formula ?? =IF((D10>(B10/2))&((F10)
How to show/hide excel worksheet using userform
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
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
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
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
to match data in one column to another and result from another column.
Hiding formula
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
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.
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
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
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
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
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
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
SolvedHi- 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
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
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
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
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
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
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
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...
Use conditional formatting to copy entire rows
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...
Page set up
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...
Bold text
SolvedHello 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?
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
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
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...
Need vba code to transfer data from sheet3 to row1 of sheet2?
SolvedHi 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
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...
Can't open ms office 7
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
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
digame cual la funcion que de daba la fecha y hora en excel
Want to create macro...help required
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
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...
Ms publisher product code
Hi. I received the MS Publisher free download. Is there a Product Key that is provided as well? Thanks
Excel - can i return a date from 2 values in different columns?
Hi everyone, I have a spreadsheet which uses weeks (1,2,3 & 4) and days (M,T,W,T,F,S,S or 1,2,3,4,5,6,7 doesnt matter which). Can I use a look up t...
Excel clarrifications...
Hi, i need to convert the values into currence words, and i got the module codes, once i pasted those codes the spellindian function is working prope...
Split data into several rows of same data
SolvedHello, I would like to split a row of data into several rows of same data in MS Excel. For example, I have an item with standard packing size of 100p...
I want to run macro and
Dear All, On daily basis i am gunning some barcode in sheet1 i also have one master excel sheet where all barcode and schedule number available and...
Warning to come up if today surpasses a certain date
Any ideas what is wrong with this formula? I want the warning to come up if today surpasses a certain date. It is to warn me of when permits need to b...
I need to know how to split a excel file in to sheets
Hi, I would like to know how to split the excel fille in to diffrent sheets based on a criteria. My criteria is , I have Headings A to Z. and ...
How to count number of cells dated this week? or next week?
SolvedI've got lots of cells with dates. I want to know how many are THIS WEEK and NEXT WEEK. I'm not sure how to do it... Help would be appreciated...
Merging information
I am taking inventory by sku number and have downloaded info from scanners and now I have it in excel and my original database is excel and I want to ...
Create a macro to move address line from 3 rows to 1 single row
I created a macro moving address data as follows to a single row: Select C1 move to B1 Select C2 move to C1 Select C3 move to D1 Select I3 move to...
Can't send email on outlook 7
SolvedI cannot send email on outlook 7 using window 7 ultimate, it's reporting error (0x800cccof) can anyone help on this? Thanks Bobosco
How to filter date-wise highest value
i have a data with two columns. first column is date and second column is amount in first column same date will be repeated for more number of ti...
Split data in excel to multiple sheets
Hello, Need help to write a macro to segregate data in one sheet to multiple sheets. I have posted a sample data below: Name Emp ID Org. Addres...
Publisher
Hi, I downloaded Publisher form Kioskea.net. I am now being asked for a "Product Key"?? What is the code please? It will not work without it
Date counting with user inputs
SolvedHello, I'm looking for a date counting formula between two dates, where the user defines the total number of days, and Excel will tell them which ...
