The discussions

Data search and corellation

Hello I have hundreds of pages of data that I am going through for Pie and Pareto analysis and I am trying to speed up the process by using formula...

Last reply on 18 Jun 2013 by
Car7os

Matching

Working on a large data that I want to match, on one hand is payments by credit cards on the other from checking. The matching is to confirm no double...

Last reply on 18 Jun 2013 by
rizvisa1

Excel - macro help please!!!

Hello, I have a monthly report with multiple clients which varies month to month. I need to figure out how to create a New Work Book from my sorte...

Last reply on 17 Jun 2013 by
TrowaD

Conditionally insert a duplicate row

 Solved

I have a table with hundreds of rows but here's a basic example: __a___b_____c____ 1 Color Dates Completed (headings) 2 red Date1 No 3 red Dat...

Last reply on 17 Jun 2013 by
TrowaD

Cell contains value from range return value from another column

How can I compare two columns of data and return a value from another column? If the value from column A on Sheet 2 contains a value from Column A ...

Last reply on 17 Jun 2013 by
jack4rall

Inserting rows chronologically while maintaining weekday formula

Hello there, In a sheet named Projects, col C contains weekday dates and col B has numbers of days needed for projects (a project takes at least 1 ...

Last reply on 16 Jun 2013 by
rizvisa1

Macro help copy specific text from one cell into another

 Solved

Here is the scenario: I have a large excel spreadsheet and I have a column in which I only need the last ten characters of each line copied or move...

Last reply on 16 Jun 2013 by
rizvisa1

How to convert a numeric value into eng. word

Hello, Please solve the question. How to convert a numeric value into eng. word Thanks & regards Rajesh Juneja

Last reply on 16 Jun 2013 by
rizvisa1

Capturing time through excel macro

Hello, I am trying to capture the timings of my team for various activities like break, meeting, working hours, login & logout timings etc...I hav...

Last reply on 16 Jun 2013 by
rizvisa1

Excel - how do i create multiple spreadsheets from one master

 Closed

Hello, I have a monthly report with multiple clients which varies month to month. I need to figure out how to create a New Work Book from my sorted...

Last reply on 16 Jun 2013 by
rizvisa1

Find a column by criteria and display in another worksheet

Hello, I have a worksheet with a several columns (example): PP DR MM SS 5 3 2 7 4 9 2 1 2 9 4 4 ...

Last reply on 15 Jun 2013 by
Mazzaropi

Trying to create a formula

Hello, what I am trying to do is that I have a $ amount in g7;g41 + 20% of the dollar amount in i7;i41 to give total payout in k7;k41 Thanks

Last reply on 13 Jun 2013 by
ac3mark

Enter data in a workbook worksheet and save it in a other worksh

Hi, I Created a excel file requisition and user input details requesting materials I need to have this data go to a other sheet with two section ...

Last reply on 13 Jun 2013 by
TrowaD

Is there a way to make a default option for autofilter?

Hello, I have an excel sheet that I am trying to display 3 different tables on, but I want to make it so that I can filter the tables down to just ...

Last reply on 13 Jun 2013 by
TrowaD

Macro to add # of rows based on data in the sheet

I am trying to make a guest list that will insert rows automatically and fill in some data. I can get the primary data from one worksheet (i.e. com...

Last reply on 13 Jun 2013 by
TrowaD

Excel - create a bulleted list in a single cell from a list

 Solved

Hello, I'd greatly appreciate some help with this: I'm trying to get a list of data in cell "D5" only from cells "A1:A10" that do have informat...

Last reply on 13 Jun 2013 by
TrowaD

Excel spreadsheet date comparison

Hello, I am trying to compare 2 columns of data to determine if one date is prior to or after another date. (Is date in column A on, before, or aft...

Last reply on 12 Jun 2013 by
aquarelle

Return selected characters in an excel cell

I have a alphanumerical number like the following: C297320 I need to return the last 3 digits of this number in a separate cell. Thus, I need...

Last reply on 12 Jun 2013 by
aquarelle

Why i cant open my pdf files even though i'm having adobe reader

 Solved/Closed

hai. i'm having new version of adobe reader, when I try to open my pdf files by double clinking on it it opens in word. when I try to select'open-wit...

Last reply on 11 Jun 2013 by
reshma

Have macro select range but exclude empty columns

Hello, I have a worksheet in which a range gets copied and pasted into an email using a RangeToHTML function from Ron de Bruin's website: https:...

Last reply on 10 Jun 2013 by
TrowaD

Vba insert new cell to a dynamic range

Hello, Hi, Could anyone plz help me to achieve what I need ? I want a code to insert and autofill a new cell to the range depending on what ...

Last reply on 10 Jun 2013 by
TrowaD

Excel solution

I have one Master Sheet, sheet1 in excel 2007 where I have entries of customer details from mixed cities Code ContactPerson Company Add1 ...

Last reply on 10 Jun 2013 by
TrowaD

Insert rows according cells value in excel table

Dear All, I need a Module that allowed me when I run it to add Rows down according upper cells Value for Example; Total Names 2 Sami 5 Rami ...

Last reply on 10 Jun 2013 by
TrowaD

If there is value in one column then a $ generates in another

Hi there, I am trying to create an excel formular where in Column G I have a drop down menu with either Long Hire or Single Hire as the options. W...

Last reply on 10 Jun 2013 by
TrowaD

Number to words

Dear Kioskes, Ex: 45,450.55, Forty five thousand four hundred and fifty & 55/100 only could please replay me

Last reply on 10 Jun 2013 by
TrowaD

Adding 1 to an existing number if criteria is matched?

 Solved

In column A I have a set of initials and in column C I want a number that corresponds to the number of times the initials have appeared... Column ...

Last reply on 8 Jun 2013 by
ac3mark

Find the sum of data that has multiple conditions in excel

 Solved

Hello, I have a large data table, and I want to find the sum for certain data that fits a few criteria. Here is a simplified example: __a_____b__...

Last reply on 7 Jun 2013 by
Kevin@Radstock

Formula

Hi, I need to create a formula for a whole team. It is based on the number of people in the office for each calendar month. The spreadsheet I have ...

Last reply on 6 Jun 2013 by
TrowaD

Pdf to excel convertor

Dear Sir, I want to install pdf to excel convertor to my PC! Help me pls!

Last reply on 6 Jun 2013 by
ac3mark

Formula for change of dates daily for one month of working days

Hello. I am looking for a formula to add one day to a column of working days in a month. I wish to start the first cell in the column to 1/07/2013 an...

Last reply on 6 Jun 2013 by
ac3mark

Vb column width and sheet name

Hi, I am really new to VB, but I work a ton with Excel. I have a spreadsheet that I have to parse out into multiple spreadsheets for some reporting p...

Last reply on 5 Jun 2013 by
hsolo30k

Excel 2010; need help w/if, then formula

I need a formula that if there are duplicate values in column A, then it will sum the values in column D for the rows with duplicate values in column ...

Last reply on 5 Jun 2013 by
ac3mark

Unable to open word file

 Closed

Hello, I recover my some deleted ms word 2007 file but it unable to open. it show the file is corrupted . i tried some method and softare but cant...

Last reply on 4 Jun 2013 by
jack4rall

Transfering data from one sheet to another, but not duplicating.

Good day all. Checking to see if anyone could help out, as iam very new to the excel world. I have a sheet that I am transferring data to another s...

Last reply on 4 Jun 2013 by
TrowaD

File convert procedure from pdf to jpg

dear sir, please give step wise procedure for converting pdf file to jpg file by return email at the earliest thanks & Regards Surekha Surve

Last reply on 3 Jun 2013 by
TrowaD

Macros for formatting a data dump

Hi All, I am new to macros and was looking if some 1 could help in coding a macros for formatting of the data. Below are the issues/Steps 1. Th...

Last reply on 3 Jun 2013 by
TrowaD

Excel: unique count of values in one column conditional 2nd colu

Hello, Column A Column B: WEST-WARD,INC. 00015 WEST-WARD,INC. 00015 HOSPIRA 00016 ROXANE LABS. 00017 GLOBAL P...

Last reply on 1 Jun 2013 by
rizvisa1

Conditional formatting in excel

I have built a GANTT chart using Excel, and have been able to create the formulae in the task bar cells that allows the proper display of those bars i...

Last reply on 1 Jun 2013 by
rizvisa1

Error when creating mailmessage

 Solved

Hello, Using Excel and Outlook 2007 I want to create an emailmessage with a Macro. But I am running into an error I can not find any "comprehensi...

Last reply on 1 Jun 2013 by
rizvisa1

Calculating days between clinic visits

Hello, I have a database with two columns, column A is date of clinic visit, and column B is patient name. I would like to be able to calculate th...

Last reply on 1 Jun 2013 by
rizvisa1

Copy data to another workbook and auto fill

Hello, First, I Have excel data base that he have information in 3 Column A(id numbers),B(First Name),C(last Name). I have another Excel workbook ...

Last reply on 1 Jun 2013 by
rizvisa1

From excel, open a word document and goto a page question

 Solved

Hello, I have an Excel document which I have inserted some VBA code to open a word document; Set WordApp = CreateObject("word.Application") Wo...

Last reply on 1 Jun 2013 by
rizvisa1

Activation key

Hello Guys, Since i formated my HD, my Ms Office pro plus 2010 keep displaying YOUR MS OFFICE COPY IS NOT ACTIVATED, code error 0x8007232B. who can ...

Last reply on 1 Jun 2013 by
Ambucias

Outlook 2007 wont recieve mail

HI, I recently changed my OS and then had to install microsoft-office, when i configured my outlook, it does not download any inboxes yet on my other...

Last reply on 31 May 2013 by
jack4rall

Error while sending mail via distribution list ms 2007

Hello, Dear All, I'm using outlook 2007 for years and my operating system is windows 7. I have created distribution lists long ago and use them almos...

Last reply on 31 May 2013 by
sofortymazi

Create macro to search for a cell value

I have 2 separate excel (2010) workbooks I'm working with and I would like to create a macro that, when run, will copy a variable value that is in cel...

Last reply on 30 May 2013 by
TrowaD

Making a counter in excel..

To Whom this may concern, I have been trying to make a counter on excel. I have been reading some of your posts but they talk about counter with a...

Last reply on 30 May 2013 by
TrowaD

Max value in one coulmn based upon another column

 Solved

Batch Price Column C 00015 2.75 00015 2.9995 00016 1.89 00017 0.56116 00018 0.1421 00018 0.11808 00018 0.1605 00018 0.12575 00018 0...

Last reply on 30 May 2013 by
Piggy70

How to extract particular data's from sheet 1 into sheet 2

Hello I have three different columns in Sheet 1 with names Number, Step Description and Results. Each column have data's up to 100 rows. I want to ...

Last reply on 28 May 2013 by
TrowaD

Transferring data from a column into several rows

I have data in a column on one sheet that needs to go into several rows in another sheet. Example: Column A has the following data (A1:A200): 1 2...

Last reply on 28 May 2013 by
TrowaD
Results 4601 - 4650 out of a total of 12,264