The discussions

Copy colum issue

Hello, My name is Lee Diaz I've been trying to organice and control my inventory of movies, For now I've been having to scan with a barcode scaner,...

4 replies Last reply on 31 Jan 2013 by
TrowaD

Excel 2007 resetting cells to date format

 Solved/Closed

Hello, I have an Excel 2007 spreadsheet that is resetting all the data cells to Date format. Have anyone seen this before? I don't think I have a vir...

11 replies Last reply on 30 Jan 2013 by
Archit Badwe

Transpose and removing duplicates at same time

Hello, I have a spreadsheet with two columns. The left column is an eight digit house ID. The right column represents miles driven by individual...

2 replies Last reply on 30 Jan 2013 by
jamesfly

Need a macro to sum range of cells

Hello, I am a teacher from Greece and I want your help to gather information and sum from different worksheets in different workbooks to another f...

5 replies Last reply on 29 Jan 2013 by
rizvisa1

Product key

Hello, Where do I find the product key to enter for a free version of MS Publisher that I just downloaded?

1 reply Last reply on 29 Jan 2013 by
rizvisa1

Worksheet name input to move data from one worksheet to another

I have a worksheet that is identical in all values other than price. All data is collected on worksheet one. Work sheet one has a column where a...

2 replies Last reply on 29 Jan 2013 by
rizvisa1

Excel - a macro copy to cell based on a specific criteria

Hello, how to split the data from state wise using macro ex: Location type month year state India email 12 2012 UP India email 12 2012 ka...

2 replies Last reply on 29 Jan 2013 by
rizvisa1

Not be able to send more than one mail from outlook

Hello sir, I am not able to send more than one mail from outlook, during mail merge sending please short-out my problem as soon as possible.

1 reply Last reply on 28 Jan 2013 by
marshalhubs

Conditional formatting

 Solved

Hello, I'm using Excel 2010 and need to conditionally format a cell based on various values in different cells. Specifically, if cell A2 states B...

4 replies Last reply on 27 Jan 2013 by
Harters

Microsoft project software

 Closed

Hello, I just downloaded Kioskea's free software program for Microsoft Project 2007. After the download and during the activation process the progra...

1 reply Last reply on 26 Jan 2013 by
rizvisa1

Comparing two spreadsheet data

Hello, Please help me out on this issue. If I have an original sheet comprising of 8 columns and a number of other row items with subtotals in be...

5 replies Last reply on 26 Jan 2013 by
rizvisa1

Simply cannot find an answer

 Solved

Hello, I have a spread sheet - column B lists dates for the last time a report for each product was completed. Each report is due every 28 days. ...

8 replies Last reply on 25 Jan 2013 by
mona3

Saved excel will not open

Hello, I got a shock when trying to open excel sheets. The message " THERE WAS A PROBLEM SENDING THIS COMMAND TO THE FILE" i can't open any saved exc...

1 reply Last reply on 24 Jan 2013 by
rizvisa1

Power point help!

Hello, I can't open a power point presentation i the format PPTX. I have Microsoft Office 2003 what should i do? Configuration: Windows XP / ...

4 replies Last reply on 24 Jan 2013 by
sylveths

Activity reminder from excel column

Hello, I would like to reserve a column "B" on an excel spreadsheet to put a date in the field for "Next Activity Date". Then put the date in the...

3 replies Last reply on 23 Jan 2013 by
rizvisa1

Vb issue with delete rows with specific values

 Solved

Hello, I am using 2007 excel and have the VB doing 2 things: 1) looking at specific Column for EXACT values and deleting row 2) looking at speci...

8 replies Last reply on 23 Jan 2013 by
rizvisa1

Roster with each person getting their own weekly sheet printed

Hello, Ive put together a spreadsheet for work, where we have a main page called roster, the whole weekly roster for all staff members goes onto t...

8 replies Last reply on 23 Jan 2013 by
rizvisa1

Macro help: copy data from a range of sheets to a master sheet

 Solved

Hi, I'm looking for some help developing a macro to collect data from a range of sheets in a workbook, but not all sheets. The macro needs to: ...

7 replies Last reply on 23 Jan 2013 by
supermate

Tagalog

 Solved

Hello, Hi! Is there anyone here knows how to speak Tagalog? If so, please let me know..I just have a few questions regarding in Excel. I cant ex...

2 replies Last reply on 21 Jan 2013 by
flower_girl

Unable to download attachment

Unable to download flash drive, PDF and download attachments. Configuration: Windows 7 / Internet Explorer 9.0

1 reply Last reply on 21 Jan 2013 by
jack4rall

Microsoft publisher 25 character key

 Closed

Hello, I downloaded microsoft publisher 2010 here. What is the product key? Please. Configuration: Windows 7 / Chrome 24.0.1312.52

1 reply Last reply on 21 Jan 2013 by
aquarelle

How to convert number into text in excel

 Solved/Closed

Hello, pls.send me formula to convert number into text in Excel e.g.100001 in words like' one lakh one only"

9 replies Last reply on 21 Jan 2013 by
Raj

How to make foxit reader to read aloud just one paragraph?

Hello, I don't want it to read the entire page, just one paragraph at the time. Is that possible? Thanks Configuration: Windows 7 / Firefo...

1 reply Last reply on 19 Jan 2013 by
Zohaib R

Unable to install ms-office

Hello, i have problem when installing the ms office.....it doesnot instal in my system.....please help me.... Configuration: Windows XP / Fir...

1 reply Last reply on 19 Jan 2013 by
jack4rall

Camparing two coloumns in excel and copy another cell value

Hello Sir I have two excel files where I want to match file1 Coloum A with File2 Coloumn A If match found File1 Coloumn C cell value should copy to...

1 reply Last reply on 18 Jan 2013 by
basri hamid

Adding a new entry into a list - excel 2007

 Solved/Closed

Hi Hope that someone can help me with this problem..... I've created a list in Excel 2007. I've added 3 colours in the list (blue, red, green). I ...

12 replies Last reply on 18 Jan 2013 by
confused

Need help with macro for 2 worksheets

Hello, I've seen examples close to what I need, but I'm not an experienced macro person and I don't know how to tweak them to get what I want. ...

2 replies Last reply on 17 Jan 2013 by
mjaybee

I need help getting info from one worksheet to copy to others

Hello, I have an Accounts Receivable worksheet for each year. I want to log each entry into the main spreadsheet and then into a separate worksheet b...

1 reply Last reply on 17 Jan 2013 by
TrowaD

Hi, need some help - copy pasting and creating coments! thanks

Hello, Getting a little stuck - would anyone know how to copy text/number from one cell and with one function: in a new cell create a comment AND ...

7 replies Last reply on 17 Jan 2013 by
TrowaD

Vlookup range question

 Solved

Hello, =VLOOKUP(A4,OLD!$A1:$B1404,2,FALSE) I'm using this formula in my spreadsheet and it is working EXCEPT when the new spreadsheet has inse...

1 reply Last reply on 17 Jan 2013 by
mjaybee

Colour column based on dates

Hello, I'm having a hard time to figure out a formula that colour the column with respect to dates. Can anyone help me out on this please..here's...

6 replies Last reply on 17 Jan 2013 by
Angga

Microsoft publisher

Hello, I downloaded the Microsoft Office Publisher from this site. But now it's saying I need an activation code. Am I missing something? Activati...

2 replies Last reply on 16 Jan 2013 by
leannawinell

Outlook certificate to send sms

Hello, I am trying to add SMS functionality to Outlook to make a notfication system (e-mail and SMS.) I got an idea from this page http://www.oze...

1 reply Last reply on 16 Jan 2013 by
rizvisa1

Macro which can countif on multiple criteria and export result

Hello, I have to create a macro, which can count for me how many of different categories of services we have. there are around 20 main categorie...

1 reply Last reply on 16 Jan 2013 by
rizvisa1

Macros

Hello, I'm new to Macro's and now wanted to learn how to run a macro based on the column values. Eg: If in column D has a values and if D3 has ...

3 replies Last reply on 16 Jan 2013 by
rizvisa1

New in ms excel

Hello, Morning! Anyone can help me? i dont understand what ive read in wiki about macros. i dont know how it works even in simple excel! Can y...

2 replies Last reply on 16 Jan 2013 by
flower_girl

Macro - concatenated cells until if finds a blank cell

Hello, Please assist. Im trying to concatenated cells with text until it finds a cell with no text then it stops current continate then continues...

1 reply Last reply on 15 Jan 2013 by
TrowaD

How to useing percentage formula in excel

how to useing percentage formula in excel Configuration: Windows 7 / Chrome 24.0.1312.52

1 reply Last reply on 15 Jan 2013 by
Zohaib R

Outlook - "unknown error" ox800ccc81

 Solved

Hello, re https://ccm.net/faq/5929-outlook-unknown-error-ox800ccc81 would you have a fix for this with Outlook Express? thanks Configuration:...

1 reply Last reply on 15 Jan 2013 by
marshalhubs

Adding the same action to every second line

 Solved

hi guys, i wonder if you could help me with the following: there is a worksheet where column A is full with numbers. I would like to add to ever...

8 replies Last reply on 15 Jan 2013 by
Dg83

Sum certain cells in a column if corresponding cells of another

Hello, I want to sum certain cells in a column if corresponding cells in another column contain a certain letter. I have amounts in cells G2:G1...

1 reply Last reply on 14 Jan 2013 by
rizvisa1

Conditional equation

Hello, I am desperately trying to write a formula for the following: If C23 is less than 2 but greater than zero, then value of E14, and if not,...

1 reply Last reply on 14 Jan 2013 by
rizvisa1

Formula to measure percent of checklist complete

Hello, I am trying to build a checklist where if you have completed the task on the list, you put an X in the cell below that task. As tasks...

1 reply Last reply on 14 Jan 2013 by
TrowaD

If, then formula

 Solved

Hello, I am creating a spreadsheet for the company airplane. Part of it is to calculate how many of the miles flown were "occupied" (had passengers...

2 replies Last reply on 14 Jan 2013 by
eaglewings1983

Counting between two given dates

Hello, I need help. I need to count on Excel 2007 between two dates including the start date and end date. But the DatedIF fdoes not work. and...

8 replies Last reply on 14 Jan 2013 by
TrowaD

Using character map in windows 7

Hello, i am using Open Office Writer and i have two questions : First : i want to write arabic numbers directly without using menu bar ( in...

3 replies Last reply on 14 Jan 2013 by
rizvisa1

Convert date into month name

 Solved/Closed

Hello, suppose date has mention 1/1/09 and no month name then how to get the month name

20 replies Last reply on 14 Jan 2013 by
Manoj

Macro to copy data under matching column header

I am trying to write a macro to copy data from multiple spreadsheets and get the data to paste into the proper matching headers. Here is what I have s...

4 replies Last reply on 13 Jan 2013 by
rizvisa1

Copy excel 07 sheet to other & keep formulas?

 Solved/Closed

Hello, Is it possible to copy an Excel 07 spreadsheet to another window spreadsheet (not another tab but completely different spreadsheet) and keep t...

8 replies Last reply on 13 Jan 2013 by
limitdydx

Excel - active x combobox, selecting sheets

 Solved

Hi, Am a newbie in trying to automate Excel. I have a workbook with 50 worksheets and a menu sheet. On the menu sheet I created a Actixe X ...

5 replies Last reply on 12 Jan 2013 by
rizvisa1
Results 4901 - 4950 out of a total of 12,259