The discussions

Clicking data in one sheet..saving all those clicked in another.

 Solved

Hello, I'm working on excel which has names(Col A) numbers (Col B). I'm looking to create a sheet, who by clicking on the number, stores the number ...

4 replies Last reply on 8 Sep 2015 by
sram

Same date in column a on mutiple lines in seperate worksheets

 Solved

Hi, Not using FILL with copy/paste....Is there a way to create a date range in Column A (IE: 9/1/15) from line 1 going downward when entering multi...

3 replies Last reply on 7 Sep 2015 by
TrowaD

Acrobat reader

 Solved

Hello, I get a prompt that my acrobat browser plugin is missing and need to reinstall. Do I need to download the software again? Configuration...

2 replies Last reply on 3 Sep 2015 by
Margaret

Please help in getting data clubbed in one cell

 Solved

Please inform how to get the following information clubbed in a row Data as follows Required data in a ...

3 replies Last reply on 3 Sep 2015 by
TrowaD

Master sheet to work sheet,

 Solved

I have been getting help at this site and I am not able to get into my messages to respond anymore. I am not sure if it is just a work computer issue ...

29 replies Last reply on 3 Sep 2015 by
vcoolio

Accounts data requires automatic analysis

 Solved

Five columns headed Value, Type, Food, Household, Medical. The data is in Value and Type listed alongside each other. I wish to have those transfer...

2 replies Last reply on 2 Sep 2015 by
249ccjames

Custom sorting & calculating average based position

 Solved

please help me with this. i want to get the position based on average. but when i put all these in a table, all are getting jammed. please can u h...

2 replies Last reply on 31 Aug 2015 by
oluwaridenawa

Search word from list, match it copy values next to it

 Solved

I have a list of product part numbers in one excel document. Now I need to pull the description and pricing from another document which is attached in...

2 replies Last reply on 31 Aug 2015 by
haris1989

Concatonating within commands???

 Solved

Ok - I know I said no more scripting, but ... Im still with Excel (VBA) macros and trying to find a way of inputting data from a html sheet (stored...

4 replies Last reply on 21 Aug 2015 by
BrianGreen

Impact font

 Solved

hello, is the impact font included in windows 8.1. Configuration: Windows XP / Firefox 40.0

1 reply Last reply on 20 Aug 2015 by
xpcman

Comparing columns and returning value

 Solved

Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: C...

14 replies Last reply on 20 Aug 2015 by
TrowaD

Word "false" kept on appearing? =if function

 Solved

=IF(ISNUMBER(A1),IF(ISNUMBER(B1),IF(ISNUMBER(C1),IF(AND(A1,B1,C1),SUM(A1,B1,C1),"Incomplete Data")))) How is it happen that I put "Incomplete Data"...

2 replies Last reply on 19 Aug 2015 by
InfoTech04

Sumproduct based on relative cell

 Solved

Hello, I can use sumproduct based on information contained in the same range of rows of a column adjacent to it, but I can't figure out how to do ...

2 replies Last reply on 19 Aug 2015 by
BrianP

Stack range of data to next empty row in other sheet

 Solved

Hello, I have a set of data in Sheet1 Range("D24:D50") and Range("AC24:AC50") would like to be copied and paste special value to Sheet2 Column A a...

4 replies Last reply on 18 Aug 2015 by
Milli

Macro that kills a macro when a new workbook is opened.

 Solved

Hi All, I am still new at excel macros. I am using a command button to copy all work sheets in a workbook then pasting just the values into a new w...

5 replies Last reply on 17 Aug 2015 by
ac3mark

Exchange .edb corrupt

 Solved/Closed

hi all, Had an exchange server go down, got the exchange .edb files only to find its corrupt, tried to use eseutil.exe to repair the file but when ...

1 reply Last reply on 14 Aug 2015 by
FrancisHancock

Excel, how to use macros and conditioning.

 Solved

Hello, I have been looking up how to use excel to help sort data but ran into a few problems. First I have searched how to delete a row with certain...

2 replies Last reply on 13 Aug 2015 by
Matt

Using 'rept' inside 'if'

 Solved

Hello, i want to do a rating..example.. Artist Rating(numerical) Rating(graphical) akon ...

2 replies Last reply on 13 Aug 2015 by
dinu

Date formula

 Solved

Hello, Can someone please create a formula for these numbers to change to a date. 152030355A, the answer should be 7/22/2015. The first two nu...

9 replies Last reply on 12 Aug 2015 by
Judy

Outlook 2003 pptx attachment won't open

 Solved

Hello, I have Outlook 2003 and was emailed a pptx attachment. When I double click it, it always asks to save instead of opening it. Docx files ope...

3 replies Last reply on 10 Aug 2015 by
van_veen

Fetch data

 Solved

fist sheet Leader id Brand Status product S001 Maruti complete Maruti 800 s002 Toyota complete xyz s003 Maruti complete swift desire s004 Nisha...

3 replies Last reply on 10 Aug 2015 by
vcoolio

Problem with open doc files in ms

 Solved

Hello, I have several .doc files with .xls files (both 97-2003 versions) embedded. When I open the .doc file in Word 2010 and try to open the .xls...

2 replies Last reply on 9 Aug 2015 by
baruraf2015

Stop outlook from transfering emails from my

 Solved/Closed

Hello, Everytime I open my outlook it transfres all of my comcast emails to outlook. How do I stop this? Thanks, Harri

19 replies Last reply on 7 Aug 2015 by
Bugs bunny

Need vba code to create loops please

 Solved

I have done loops before but it has been a long time. I need to loop through rows of data and the rows of data changes. The value in column "N" is t...

6 replies Last reply on 31 Jul 2015 by
FaizanRoshan88

Vba

 Solved

I want to append the month name at the end of the tab names in my workbook I have 86 tabs which are named by employee name and every month I want to ...

2 replies Last reply on 30 Jul 2015 by
looneybin

Formatting cells

 Solved

I'm stuck.... I am creating an invoice of sorts for a company who deals in different currencies. Q1. I have created a drop down list of all products ...

2 replies Last reply on 28 Jul 2015 by
Stace123

The object is corrupt - in word 2003

 Solved

We have a document that has several objects (Excel tables) in it. We update the tables each month and then "save-as" the new month. We have one tabl...

2 replies Last reply on 28 Jul 2015 by
fazekasbence

Exchange 2007 corrupt database

 Solved/Closed

I'm running Exchange 2007 Enterprise on Windows 2003. I have about 10 databaes that are running. I reboot the server this morning due to some updates ...

2 replies Last reply on 28 Jul 2015 by
enzocalleros

Cutting last 10 charecters of a cell and pasting to next cell

 Solved

Hi Guys - Im back again with another excel macro problem. I can find all sorts of advice when I google this, but none of it quite matches my needs so ...

4 replies Last reply on 28 Jul 2015 by
TrowaD

Microsoft project 2007 corrupting data

 Solved

I have a split situation. At work I use MS-Project 2007 and at home 2003. To ensure transportability filers are always saved in 2003 MPP formats. ...

1 reply Last reply on 28 Jul 2015 by
aidanthomas

Opening a corrupted illustrator .ai file

 Solved

We have an Illustrator CS2 file, that a co-worker has been working on for the last month, that is now telling us unknown error has occured. We have...

1 reply Last reply on 28 Jul 2015 by
williammcdowell

Illustrator file damaged and could not be repaired

 Solved

its been coming more and more common for my files to become damaged and not be able to open for me. It started with files that had an insane number of...

2 replies Last reply on 26 Jul 2015 by
myleszikiom

How to restore xls?

 Solved

We had a need to factory restore our PC. It is Windows 7 Home Preimum with SP1. We copied all data off ran the factory restore drive, reinstalled Offi...

1 reply Last reply on 26 Jul 2015 by
danielriqueti

Excel formula needed to count a list of names

 Solved

Hi This is probably an easy one for the pro's, basically I have a list of names that will change as reports are generated. The report will inclu...

8 replies Last reply on 25 Jul 2015 by
LINA

Publisher 2007

 Solved

Hello, My computer crashed purchased a new one and am reloading software. I have my Publisher CD but no longer have the key. I called microsoft and th...

2 replies Last reply on 24 Jul 2015 by
lmitch06

Opening pdf files in photoshop

 Solved

Hello, I am having trouble opening my pdf file that I created using photoshop CS2. I can't seem to open this file anymore, previously I could open i...

1 reply Last reply on 24 Jul 2015 by
avilsben

Conditional formatting: find text and highlight from other cell

 Solved

I have a table with names and number values alternating in a table. I add all the numerical values and highlight based on the total value for each nam...

7 replies Last reply on 23 Jul 2015 by
TrowaD

Ms outlook outlook data file cannot be accessed " while accessin

 Solved

I am unable to open my Outlook file due to corruption how to repair database .pst file of MS outlook. I was using Microsoft Outlook 2007 from last 2 y...

1 reply Last reply on 17 Jul 2015 by
davidmoore

Get data present in row1 of sheet1 copied into row1 of sheet2

 Solved

Hello, I need to get data present in Row1 of Sheet1(Central OPD) to be copied into row1 of Sheet2(Departmental OPD) based on Department Column of Sh...

11 replies Last reply on 15 Jul 2015 by
vcoolio

Outlook 2010 cannot open or access the required pst file

 Solved

Thi smorning a system has had a problem. When I try to open Outlook, I get the following error: "Cannot expand the folder. The set of folders canno...

1 reply Last reply on 15 Jul 2015 by
thijngihenne

Formula - if c2 is not blank, and b2 is blank, then copy c2 to

 Solved

Hi all - Am looking for help on formula - I want excel to look at cell C2, then if it has anything (text or numbers), then to look at cell b2. If ...

2 replies Last reply on 12 Jul 2015 by
Eirualmac

Transfer data and then apply formula

 Solved

Hello, I have a rather large spreadsheet which records the data from a number of different branches on each separate worksheet (labelled as "branche...

3 replies Last reply on 9 Jul 2015 by
Hydro

Copy formulas across workbook

 Solved/Closed

Hello, I want to copy Excel 2007 formulas from one workbook and past to the other workbook without the workbook name in the pasted formulas. Can ...

9 replies Last reply on 8 Jul 2015 by
1234551

Macro to copy/paste specific range every 3 rows

 Solved

Hello, I am beginner in VBA and now have an Excel sheet with about 4000 rows, where I could need a macro. I already recorded a macro for the fi...

2 replies Last reply on 7 Jul 2015 by
Isa

Need urgently to find a macro in excel report across sheets

 Solved

Hi, Anyone a solution? I need a macro that will do the following: 1. Search for a word, a number, ... across all the worksheets in the workbo...

6 replies Last reply on 7 Jul 2015 by
moisdois

Error trying to populate new worksheet using macro

 Solved

Hey everyone, I've been working on a macro to create a new worksheet based on the information entered into a column of a "data" worksheet which pop...

2 replies Last reply on 30 Jun 2015 by
AmitMehta96

Add string only if a text is present in a cell

 Solved

Hello, i have this string =CONCATENATE(MID(B5;1;1);".") i use to have the initial of a name like this: from "Name" to "N." but some fields have no...

6 replies Last reply on 30 Jun 2015 by
Deloro

Copy cell from another sheet where cell is value...?

 Solved

Hi, Is it possible to copy a cell from sheet 1 to sheet 2 where (for instance) sheet 2 A1 is same value as a cell in sheet 1? What I have is: sh...

2 replies Last reply on 30 Jun 2015 by
wzshop

Macro for filling data from specific cell to another

 Solved

Hi all, i need help with creating macro to fill data from specific cells in column to another specific blank cells in other column. screen shot i...

4 replies Last reply on 30 Jun 2015 by
kayuf

Error: embedded excel spreadsheet

 Solved/Closed

Occasionally I have an error with my embedded spreadsheets- it is "Microsoft Office Word can't start the application required to open this object. An...

1 reply Last reply on 28 Jun 2015 by
MatthewBon
Results 801 - 850 out of a total of 2,599