The discussions

Changing date format

i am unable to change my date format in excel sheet. please help me

1 reply Last reply on 23 Oct 2013 by
ac3mark

Converting rows of data into columns

 Solved

Hi everyone, I hope you all can help. I have a file in with 17,000 lines of data in rows that I need converted into columns. I don't work with Ex...

3 replies Last reply on 22 Oct 2013 by
chuaf24

My outlook e-mail is not working

Hello, I am having a problem sending and forwarding e-mails from my Outlook. Do not know how to solve the problem. Can you help me? Configurati...

3 replies Last reply on 22 Oct 2013 by
ac3mark

How can i create a macro for a new spreadsheet

Hi I need to create a Macro that generates a new spreadsheet based on the values that have an X on the third column. Here is an example of the data. ...

1 reply Last reply on 21 Oct 2013 by
ac3mark

Macro to traspose data

 Solved

Hi I need a help I need to transpose my data following way for a longitudinal analysis; ID Day1 Day2 Day3 Day4 Day5 Day...

5 replies Last reply on 21 Oct 2013 by
TrowaD

Want one cell to be highlighted if i type something in next one

 Solved

Hello, I want B1 to be highlighted as green if i type any text in C1. Please help me. Regards Saurabh

2 replies Last reply on 20 Oct 2013 by
Saurabhmitra07

Conditional formatting a single cell based on another range

 Solved

I have been trawling around looking for a solution to my problem. I need to highlight/colour a single cell when its value appears in a row elsewher...

2 replies Last reply on 20 Oct 2013 by
hussar

Auto generate worksheet from a list

Hi Can anybody help me please..........:-) I am trying to set up a "defect register" in an excel worksheet whereby information inputted into a ...

3 replies Last reply on 17 Oct 2013 by
TrowaD

Vba code which append all the data to the master sheet

I have A Master Excel sheet which I have linked to 15 different excel files with same variables. I need a VBA code which append all the data to the Ma...

1 reply Last reply on 16 Oct 2013 by
ac3mark

Excel vba

please know how create in userform in excel and vba of Find Add, Update and Delete Just from User form | I have already made User form

1 reply Last reply on 16 Oct 2013 by
ac3mark

Conditional formatting a cell if a certain word is met

 Solved

Hi I am trying to conditionally format cell B3 if the criteria in cell C3 = NAT I am able to do it if it was a number but not if its a word, If the ...

2 replies Last reply on 15 Oct 2013 by
scarey3

Transfer row entries onto another spreadsheet/form

Hi Can anyone help... I am trying to link information from one spreadsheet onto a form my office are using. At present they make an entry into ...

1 reply Last reply on 15 Oct 2013 by
TrowaD

Need some excel help please.

Hello, I am trying to auto populate a singal didget number from a date off of a spread sheet into another spread sheet. could someone please he...

1 reply Last reply on 14 Oct 2013 by
TrowaD

How to capture highest/lowest values/dates over time

I'd be grateful if anyone knows the answers. I've been using an Excel spreadsheet to determine the total value of stocks I own. Basically I ent...

13 replies Last reply on 14 Oct 2013 by
venkat1926

Conditional formatting

I want to do conditional formation in that i have two columns where A (Due Date) & In B ( Remark) if my validation due date is pass then i want to h...

1 reply Last reply on 12 Oct 2013 by
venkat1926

Adob reader can't save form

Dear All, I created pdf fill form from Bluebeam and when i open that pdf form with Adobe Reader, even i can fill out but i can't save direct to that f...

3 replies Last reply on 11 Oct 2013 by
Ambucias

Reference one column and compare to columns on other worksheets

I am trying to compare zipcodes from other worksheets compared to the main worksheet to return a true or false value. Help please!

3 replies Last reply on 11 Oct 2013 by
dbowley

Build macro routine

I've tried but failed. Can anyone build an excel macro just to copy a row of 3 cells and paste down the blank cells until the next filled cell, then ...

8 replies Last reply on 11 Oct 2013 by
gchancga

Date manipulation

Hi, I have 4 columns approx 250 lines long. They contain expiry dates in the dd/mm/yyyy format. I wish to compare these dates against another da...

3 replies Last reply on 9 Oct 2013 by
Mazzaropi

If formula showing date

 Solved

Hi all, I created a spreadsheet that has a date in and a date out columns, the dormula I use on the date column is: =if(d2,TODAY(),""). Formula is in ...

2 replies Last reply on 9 Oct 2013 by
simeonmein

Excel - calculation based on dynamic criteria

Good day, I have this question as followed:- I have a table as attached file where I already created a macro to repeat the lines based on the (rou...

2 replies Last reply on 9 Oct 2013 by
wliang

Excel formula for percentage of...

Hi there, I'm having tough time with this one and I would really appreciate help. My 'F' column contains different values including 0 (zeroes). I ne...

5 replies Last reply on 8 Oct 2013 by
TrowaD

How to split a cell based on #27 line break

Hi All! First to all thanks a lot for your assistance! :) I'm trying to split a cell into two based on the # of linefeeds that it contains. I...

1 reply Last reply on 8 Oct 2013 by
TrowaD

Auto email send to recipients update in spreadsheet using excel

Hello, I'm new to this forum. Currently I have a shared workbook that link to multiple user for update. I have a column for having the person (exa...

6 replies Last reply on 8 Oct 2013 by
TrowaD

Nested if problem

What is the problem in my formula IF Salary is less than 5000 than house rent Salary*55% but not less than 2500 IF Salary is less than 5001-10800 th...

2 replies Last reply on 8 Oct 2013 by
Mazzaropi

Excel vba: application.filesearch error

 Solved

Hello everyone, I encountered error "Object doesn't support this action." when the program the line "With Application.FileSearch". Here is my codes...

2 replies Last reply on 8 Oct 2013 by
wliang

Comparing and copy cells vba script

Hallo, I need some VBA script to compare two cells like ex: A2 with B2, A3 with B3 and if B2 or B3 is empty should A2 or A3 be copied to Sheet2( or in...

7 replies Last reply on 7 Oct 2013 by
ac3mark

List dates in column a1

In column A1 i need dates lets say 1-Nov-13 numbering for an entire year. The tricky part is i need Cell A1,2,3,4 to have the same date. 1-Nov13. t...

1 reply Last reply on 7 Oct 2013 by
TrowaD

Conditional formatting

 Solved

Hello, Does anyone know if you can set conditional formatting to highlight an entire row if the date in a specific cell is less than a week from t...

3 replies Last reply on 7 Oct 2013 by
Mazzaropi

If data matches in one column, check 2nd column matches

 Solved

I've been trying to figure this out for days, I'm sure it's possible but can't get it to work. I have a set of data - in one column there are refer...

2 replies Last reply on 7 Oct 2013 by
vickylouise

Code this in vba for excel

Can anyone code this in VBA for Excel? If active cell is not blank, then select range from current cell plus 2 cells to the right (ie A1:C1), copy ...

3 replies Last reply on 7 Oct 2013 by
TrowaD

Macros for create new excel sheet from active workbook

Hi, could you please provide a logic for create new excel sheet from active workbook, please find the my code below. Private Sub cmdCFUploadFile_Cli...

1 reply Last reply on 7 Oct 2013 by
venkat1926

Comparing two spreadsheets - deleting rows in one

Hello: I have a requirement to do the following: - Spreadsheet #1 contains several columns of product data, including SKUs. It has several thou...

1 reply Last reply on 7 Oct 2013 by
venkat1926

If function with dates

I'm building a personal finance tracker, and I'm attempting to get a function to tell me which week of the month I purchased something in. Right now ...

2 replies Last reply on 6 Oct 2013 by
kevinlewis13

Comparing text values in 2 excel sheets

Greetings all, I am looking to compare the text values in 2 Excel sheets and output them to a 3rd sheet. Trying this in Excel 2010, and am a littl...

4 replies Last reply on 4 Oct 2013 by
ac3mark

Publisher

I've downloaded the free version of publisher from yourselves but its now asking for a key. How do I get that? Ta

1 reply Last reply on 3 Oct 2013 by
xpcman

Office instant messenger

Hi, I require a software for internal office communication among office staff. Which will you recommend. Please exclude free IM (Skype, Yahoo, Gtal...

2 replies Last reply on 3 Oct 2013 by
jennie23

Help to convert a date to julian date fromat yyyyddd in excel

 Solved

hi, i have thousands of dates in format dd-mm-yy that needs to be converted to julian date format yyyyddd. dates that needs to be converted are fro...

6 replies Last reply on 30 Sep 2013 by
Calixte DORVIL

Excel:password protected sheets

Hello, I hope someone can please help me in adding a password to excel as admin and user..when a username password is entered it will show sheet 1...

1 reply Last reply on 30 Sep 2013 by
TrowaD

Macro for sending gmail

Sir I need some help my problem is follows. I have a data sheet. I will be updating every day the data sheet. I use a macro to generate a sheet ...

1 reply Last reply on 29 Sep 2013 by
Ambucias

How to return all values matching two criteria

Given this table A B C Number Sector Name 1 21144 P John 2 21144 P Mark 3 21144 P Bob 4 ...

3 replies Last reply on 29 Sep 2013 by
venkat1926

Unable to send email from my out look 2007

I have recently configured Outlook 2007 in my laptop with Windows. Unable to send emails. Getting this message Task 'Work - Sending' reported er...

3 replies Last reply on 27 Sep 2013 by
ac3mark

Editing scanned pdf files...

Hi, I have a huge pdf file made up of scanned images. I wish to edit them either in Acrobat or in Word. Problem is I cannot edit in Acrobat, beca...

7 replies Last reply on 26 Sep 2013 by
ac3mark

Is there a way to call out multiple values in single cell?

 Solved

Hello everyone, this is tricky and im not sure if i have missed something or if this is even possible, if it is it would be a huge help. I am limited ...

2 replies Last reply on 26 Sep 2013 by
Whylucky

Excel

Acc Code ..... Date.................. Amount....... Cleared C287974...... 31-Jan-13.......... 500............. Yes J320728....... 07-Ap...

4 replies Last reply on 26 Sep 2013 by
TrowaD

Create different worksheets based on data in a column

I have a huge worksheet, where I have a data by different countries, I want to split this master data into different worksheets based on the countrie...

1 reply Last reply on 26 Sep 2013 by
venkat1926

How to capture the data with using of macro

Hi, Am crating a excel form in sheet#1 as following entry's. Row Column A B C D E 1 ...

1 reply Last reply on 26 Sep 2013 by
venkat1926

Excel: matching lists with different formats

I have two lists of names that I am trying to compare. One list is divided into two cells, one for first and one for last names. The other list has ...

1 reply Last reply on 25 Sep 2013 by
Mazzaropi

Outlook can receive emails but cannot send emails

Hi, My outlook is able to receive email but cannot send emails. Please help. Sometimes my sent emails will be sent into my INBOX. I am using gmail ...

2 replies Last reply on 25 Sep 2013 by
gr8daddyg

Lock/unlock/color a range based on the value in another range

Hello, My questions relate to Excel for MAC 2011 (not PC), I am very new at VBA. I found the below code and need help to make it work. My Excel ...

1 reply Last reply on 24 Sep 2013 by
TrowaD
Results 4351 - 4400 out of a total of 12,260