The discussions

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...

3 replies Last reply on 10 Jun 2014 by
TrowaD

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...

1 reply Last reply on 9 Jun 2014 by
venkat1926

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...

1 reply Last reply on 7 Jun 2014 by
xpcman

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...

4 replies Last reply on 7 Jun 2014 by
kstar234

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...

1 reply Last reply on 7 Jun 2014 by
venkat1926

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 ...

1 reply Last reply on 4 Jun 2014 by
venkat1926

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...

2 replies Last reply on 2 Jun 2014 by
buznac

Creating a macro to find text and then merge cells

 Solved

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. ...

6 replies Last reply on 2 Jun 2014 by
TrowaD

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...

1 reply Last reply on 2 Jun 2014 by
TrowaD

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...

1 reply Last reply on 2 Jun 2014 by
venkat1926

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...

1 reply Last reply on 30 May 2014 by
ac3mark

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...

3 replies Last reply on 30 May 2014 by
Pete from NYC

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",...

2 replies Last reply on 30 May 2014 by
ravenyaad

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...

1 reply Last reply on 30 May 2014 by
venkat1926

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...

5 replies Last reply on 30 May 2014 by
venkat1926

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...

1 reply Last reply on 29 May 2014 by
venkat1926

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...

2 replies Last reply on 27 May 2014 by
Osama_bb11

Bold text

 Solved

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...

1 reply Last reply on 27 May 2014 by
TrowaD

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 ...

1 reply Last reply on 27 May 2014 by
venkat1926

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 ...

5 replies Last reply on 26 May 2014 by
TrowaD

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...

6 replies Last reply on 26 May 2014 by
shashidharga

Need vba code to transfer data from sheet3 to row1 of sheet2?

 Solved

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...

2 replies Last reply on 24 May 2014 by
hmk950

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...

1 reply Last reply on 24 May 2014 by
xpcman

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 )

3 replies Last reply on 23 May 2014 by
Ambucias

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...

1 reply Last reply on 22 May 2014 by
Ambucias

Preguntas en excel en computacion

digame cual la funcion que de daba la fecha y hora en excel

1 reply Last reply on 22 May 2014 by
Mazzaropi

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...

5 replies Last reply on 22 May 2014 by
TrowaD

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...

1 reply Last reply on 22 May 2014 by
venkat1926

Ms publisher product code

Hi. I received the MS Publisher free download. Is there a Product Key that is provided as well? Thanks

3 replies Last reply on 21 May 2014 by
Ambucias

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...

2 replies Last reply on 20 May 2014 by
junerey

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...

1 reply Last reply on 20 May 2014 by
TrowaD

Split data into several rows of same data

 Solved

Hello, 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...

25 replies Last reply on 19 May 2014 by
emily1214

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...

1 reply Last reply on 19 May 2014 by
xpcman

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...

1 reply Last reply on 19 May 2014 by
TrowaD

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 ...

1 reply Last reply on 19 May 2014 by
TrowaD

How to count number of cells dated this week? or next week?

 Solved

I'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...

2 replies Last reply on 19 May 2014 by
doublewitt

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 ...

1 reply Last reply on 19 May 2014 by
TrowaD

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...

2 replies Last reply on 19 May 2014 by
ESChomesecurity

Can't send email on outlook 7

 Solved

I cannot send email on outlook 7 using window 7 ultimate, it's reporting error (0x800cccof) can anyone help on this? Thanks Bobosco

4 replies Last reply on 19 May 2014 by
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...

1 reply Last reply on 16 May 2014 by
RayH

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...

2 replies Last reply on 16 May 2014 by
Xcellenthu

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

1 reply Last reply on 15 May 2014 by
xpcman

Date counting with user inputs

 Solved

Hello, 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 ...

3 replies Last reply on 15 May 2014 by
Plastic_Cup_of_Stars

Excel macro

Hello All, I am trying to create a macro with formula. I need help in there. I have to get a formula for a column for more than one sheet. The formu...

3 replies Last reply on 15 May 2014 by
TrowaD

Set up a macro for quarterly reports i produce

Hi, I was wondering if someone could help me... please! I would like to set up a macro for quarterly reports I produce. I would normally downloa...

1 reply Last reply on 15 May 2014 by
TrowaD

Setup userforms assetmanaging

I have the following issue, am totally unfamiliar with UserForms, but need help with next. I have an excel file which works well, now I have some ...

17 replies Last reply on 15 May 2014 by
Roelof_bakker

Create file xls based on colums & populate data with criteria

 Solved

Hi, I need a macro that create some new file (txt or xls it doesen't matter) starting from an existing xls. The existing xls named "Arretrati" h...

4 replies Last reply on 14 May 2014 by
Steveryde

Master password

 Closed

Hello, Please give me na master password Configuration: iPhone / Chrome 34.0.1847.114

1 reply Last reply on 14 May 2014 by
2011N2

Using date and if

=IF(B3="",09-01-2014,)*DATE(YEAR(B3)+G3,MONTH(B3),DAY(B3)) This is my failed furmula. I am trying to write a formula that will take the date in B3...

3 replies Last reply on 13 May 2014 by
ac3mark

Macro: cut/paste entire row into new sheet based on cell value

Hi there, I'm struggling to create a working macro that finds a specific value in a column and then, only if the condition that the cell's value eq...

1 reply Last reply on 13 May 2014 by
TrowaD
Results 3851 - 3900 out of a total of 12,258