The discussions

Creating new spreadsheet based on column - macro help!

Hello, This is my first time trying to use a Macro, so please bear with me. Anywho, I am using Excel 2007, if that helps. I have a spreadsheet th...

9 replies Last reply on 5 Aug 2015 by
venkat1926

Date formate in formula bar

hi Tried to change the date format in the formula bar but its not taking for ex: 29/05/2015 is showing as MM/DD/YYYY in formula bar but in sheet its ...

1 reply Last reply on 3 Aug 2015 by
TrowaD

Help with returning multiple values

Hi, I have 3 columns in Excel. I need to search value from Column A in Column B and return value from Column C. For example I need to find 004 f...

3 replies Last reply on 3 Aug 2015 by
TrowaD

Looking up and adding the values fixing different criteria

Hello, "A column" the name of items such as Tiles, Pipes, Tables etc (many times repeated) "B Column" the size of each item such as 10mm, 20mm, 50m...

1 reply Last reply on 3 Aug 2015 by
M.Hanzla

Comparing two columns with string

I have two columns :A (shorter list) and B (longer list). Is there a way to find all instances of B which may have any string from A? For e.g. COLU...

7 replies Last reply on 2 Aug 2015 by
M.Hanzla

Transfer from one worksheet to another with a codition

Hello, all i have question I'm trying to populate a work book in order to organized my warehouse. on the first sheet i have 6 columns with the follo...

1 reply Last reply on 1 Aug 2015 by
vcoolio

Need to add next loop in code

Thanks for this. i have little bit issue if you solve this Here is code, as you see i repeat code for next row and sheet calculation. i just want to...

6 replies Last reply on 31 Jul 2015 by
FaizanRoshan88

Cannot open pdf file attachement in my email

Hello, I can't open my PDF file attached in my email. However, I have PDF on my PC and can open PDF file in Word Document, but not in my email. ...

1 reply Last reply on 31 Jul 2015 by
BaCkToHaCk

Batch create ms project files from excel data

Hey everyone! I am hoping to be able edit a MS project template using a macro. With each project we do I have the project start date, task names, ...

2 replies Last reply on 31 Jul 2015 by
avw

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

Need help copying to another tab . .

Hello, I need to copy a row (multiple rows) if a cell in that row contains certain text. For example if C12 contains the word "expense" I need the...

1 reply Last reply on 31 Jul 2015 by
vcoolio

Common part numbers on bom

I have many many worksheets within an Excel file. Each one contains a list of components used to make a final product (assembly). This is called a BOM...

2 replies Last reply on 30 Jul 2015 by
iotcom

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

Macros or formula?

I have a report to run for work each week. Simply said, I obtain the raw data and need to sort and filter it based on a certain criteria. Then I need ...

1 reply Last reply on 30 Jul 2015 by
TrowaD

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

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

Conditional formatting where 2 statements are met

Hello, I'm trying to use conditional formatting in excel 2010 where if the data in column D is 'In Progress' and the data in column N is a % betwee...

1 reply Last reply on 28 Jul 2015 by
TrowaD

Prepare summary sheet order by items from variuos sheets in work

Hello, I need to prepare a consolidated summary sheet .(Basically Timesheet) The description of the summary sheet as below. 1. A master wor...

7 replies Last reply on 28 Jul 2015 by
laxmi

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

Search using formula

I have around 10 sheets in excel say sheet name as 1 , 2 , 3 ..... I wanted to search a word in specific sheet and get the Number from the next cel...

1 reply Last reply on 27 Jul 2015 by
TrowaD

Vba copy and paste range to next empty cell(s) to right

Hello! I'm fairly new to VBA, and I'm new here, so please bear with me as I try to explain what I need. I have a set of data that will be updated on...

1 reply Last reply on 26 Jul 2015 by
micksv

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

Conditional text based on text in another cell

Hi, I'm trying to format a cell (D2) on Excel 2007 so that when the cell next to it (E2) contains "LFC-0.3", it will say "Downregulated", but if the ...

2 replies Last reply on 26 Jul 2015 by
M.Hanzla

Date

what is the formula to convert numeric date into words in excel

1 reply Last reply on 25 Jul 2015 by
xpcman

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

Automatically copy new survey data to another sheet

Greetings, I'm trying to copy certain cells of data received via an Excel Survey to another sheet. Trouble is, when new data is received, the row num...

1 reply Last reply on 25 Jul 2015 by
vcoolio

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

Partial match of names

Hello, On Excel, I have two seperate spreadsheets. The first is with a list of names, and the second with a list of names and emails. The second l...

2 replies Last reply on 24 Jul 2015 by
bob

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

Macros to add numbers

Hello, I need to create a button and on every click of that button it should add 1 to it. For Eg first click it should take data as 1 and second ...

1 reply Last reply on 22 Jul 2015 by
vcoolio

Change date format

Hello, I Want to change date format dd.mm.yyyy to dd/mm/yyyy in MS Excel 2010 Please solve my problem urgently Configuration: Windows 7 / Chr...

8 replies Last reply on 21 Jul 2015 by
TrowaD

Need a macro to searched data in another excel

Hello, I have a requirement , where in in one excel sheet i have data with 5 columns (A, B , C , D , E) now i want to search the excel on data wit...

4 replies Last reply on 21 Jul 2015 by
M.Hanzla

Date format

Hello, In my system date is in dd/mm/yyyy but I required in this format dd-mm-yyyy how it will possible pl let me know Configuration: Win...

1 reply Last reply on 20 Jul 2015 by
TrowaD

Downloading files

Hello, I am having trouble when trying to open downloaded files in Microsoft Word 2007. The files will not open in English but some foreign langu...

3 replies Last reply on 19 Jul 2015 by
Ambucias

Condition formatting on changing cell color based on another cel

hi, wanted to check if it's possible to do condition formatting on cell color based on another cell's text. For example I have cell A1 with Text Pa...

1 reply Last reply on 17 Jul 2015 by
Mazzaropi

To copy data to other workshet by suming the value based on co

Hello, I am having table like below with large data in DATA.xlsx file Pls see attached file for table details My requirement is to selec...

1 reply Last reply on 17 Jul 2015 by
ashishvb

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

Auto populating from one spreadsheet to another

HI there, this is my first question and I am hoping someone can help me please. I am setting up a database in excel and I am an basic to intermedia...

3 replies Last reply on 16 Jul 2015 by
vcoolio

Need formula to populate total sales for each employee by month

Hello, Im working on a spreadsheet and i cant come to a formula that works for me. I want to total the amount of apples each employee sold e...

1 reply Last reply on 15 Jul 2015 by
Mazzaropi

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

Unable to open a pdf attachment

Hello, I am unable to open up PDF attachments from one sender. i do not have this issue when opening PDFs from other senders. Configuration: W...

2 replies Last reply on 15 Jul 2015 by
DMG

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

Copying rows to certain worksheet

Hello, I think i can accomplish this without a macro but can figure it out. I have a project list on sheet1, I would like to copy a projects row to...

1 reply Last reply on 15 Jul 2015 by
vcoolio

Last value in a row

Hello, I want a cell which is a summary of the entire row values, but it should display the latest value in the row.Suppose I have entered a value a...

1 reply Last reply on 14 Jul 2015 by
Mazzaropi

How do you specify a different location to save the file to?

Hello, I was wondering if you could tell me how to save this file to a different location than where the current file is saved? Configuration: ...

1 reply Last reply on 14 Jul 2015 by
TrowaD
Results 2901 - 2950 out of a total of 12,266