The discussions

Formula to add 1 with if statement

 Solved

Hi, Here's the breakdown of what I'm trying to do: The formula is going in cell 'Y28' and I'm attempting to do two different things: 1) I want...

2 replies Last reply on 8 Dec 2015 by
edmaclod

Formula issues with various variables

Hello, I appreciate the time the forum are taking to view my message. I'd very much appreciate it if someone could help me, as I'm trying to make ...

1 reply Last reply on 7 Dec 2015 by
ac3mark

Ms office 2007 work on windows 7 ultimate or not

Hello, ms office 2007 enterprise work on windows 7 ultimate or not ? please reply ...... Configuration: Windows / Firefox 29.0

1 reply Last reply on 7 Dec 2015 by
xpcman

Transfer data automatically from one sheet to other based in

Title->Transfer data automatically from one sheet to other based in specific dates. Hello and sory for my long title. How can transfer data from a c...

4 replies Last reply on 7 Dec 2015 by
NickBR

Forgot cyber cafe pro's admin username and password

 Solved

please can somebody help me. after installing cyber cafe pro 5 for just 4 machines, I completely forgot the admin username and so I decided to unins...

3 replies Last reply on 5 Dec 2015 by
Unknown

How to remove mark up area in microsoft word 2007

 Solved/Closed

Hello, How to remove mark up area in word file Configuration: Windows 7 / Firefox 29.0

Last reply on 5 Dec 2015 by
Asrar

Updating existing worksheet

Hello, everyone I hope everyone's holiday's are great. I want to thank everyone in advance for their help with this situation I am having in excel. ...

1 reply Last reply on 5 Dec 2015 by
rizvisa1

Not pasting values in excel file

 Solved

Hello, I would like to know that I have a Excel Macro Enabled File. it has macros, sheet vba code, modules and user forms code and no merging...

2 replies Last reply on 5 Dec 2015 by
smuneeb

Sort

Hello, On Column A I have DATES Column B a code (D1111, D2222) Column C Vendor num Column D Client num I want to be able to identify when f...

1 reply Last reply on 4 Dec 2015 by
rizvisa1

Coping formulas to next row using a macro

 Solved

Hello, I am trying to make a macro to copy a formula to the next row in a spreadsheet. Then paste the absolute values back into the original row. I...

6 replies Last reply on 4 Dec 2015 by
CADU1947

Vba code

I dont know how but I managed to put together a macro that copies transposed info entered in a column of one sheet to a row in another sheet. The prob...

1 reply Last reply on 4 Dec 2015 by
rizvisa1

Restriction of @ and .com

Hello, Thank you for your reply, I have another question, if you can help me with that too? I want to add a restriction in a column for suppose C co...

1 reply Last reply on 4 Dec 2015 by
rizvisa1

Compare data in two excel sheets

Hello, I have huge data in two different excel sheets (same work book), approx. 10 columns & 5000 rows. I want to compare both the sheets and find...

1 reply Last reply on 4 Dec 2015 by
rizvisa1

Excel sheet alphabet count

Hello, How can I count alphabet on excel sheet. kindly send me the details Thanks & regards Pulakesh Medhi

1 reply Last reply on 4 Dec 2015 by
rizvisa1

Subtraction total

Good evening, please anyone who can help me, i have in cell J5 all products eg. 20 parts. In cells L5:W5 add how many parts i have used. How i will ...

1 reply Last reply on 3 Dec 2015 by
ac3mark

Add a restriction to a column

 Solved

Hello, Can you please help me out, I'm stuck. I have to restrict the numbers 03 in a column that must contain 11 characters ( the number should st...

1 reply Last reply on 3 Dec 2015 by
rizvisa1

How to find a blank cell in particular column?

Hello, I want o identify the blank cell in Particular column, and in this my blank cell is my last cell even it would be helpful if anyone suggest...

1 reply Last reply on 3 Dec 2015 by
rizvisa1

How to copy multiple lines with a macro

Hello! I have never worked with Macros but I strongly believe they could save my current data crunching work (that I need to finish by tomorrow or ...

4 replies Last reply on 3 Dec 2015 by
TrowaD

Conditional formatting through macro

 Solved

Hello, I would like to request that how Conditional Formatting would apply through Macro and the Conditions are Range is E11 to E510 if Colum...

9 replies Last reply on 3 Dec 2015 by
vcoolio

Excel formula needed

Hello, Need excel code for min(1-5), N or X Example data: 1. 3. 5. 2 X. --> 1 X. N. X. X. N. -->N X x x x x x x. --> x X 3 2 N. X N...

1 reply Last reply on 2 Dec 2015 by
rizvisa1

Sum values from one column if another column equals x

 Solved

Hello, Is there a formula that can calculate the sum of cells from one column if the value in another specific cell equals x (or not blank)? I tried...

3 replies Last reply on 2 Dec 2015 by
vcoolio

Vba - copying data to new sheets

Greetings Excel experts, I'm trying to figure out how to tackle a problem. Basically, I have a master sheet with a bunch of data and I would like ...

2 replies Last reply on 2 Dec 2015 by
vcoolio

Weird date display in excel

Hello, This seems like a really simple problem to solve but totally has me stumped. I have entered my date as 30/11/15 (DMY) into the excel cel...

3 replies Last reply on 1 Dec 2015 by
ac3mark

Worksheet_change event

Hello, I have a vb script worksheet_change I am trying to get a conditional If like statement to work in the code where a condition is met from...

8 replies Last reply on 1 Dec 2015 by
RayH

Retrieve data from column a based on condition from column b

I have a set of data in a column. Say like below: Col A Sets Apple 1 Apple 1 ...

3 replies Last reply on 1 Dec 2015 by
rizvisa1

Autocopy row based on whether the cell in a certain column is

Hello, I have a detailed aging report that I am attempting to create monthly tabs in. Basically what I need is a macro that will auto paste the en...

3 replies Last reply on 1 Dec 2015 by
TrowaD

Going paperless - form replacement - suggestions please.

Hi All, I have no idea how to ask this, so please bear with me on this. My wonderful boss has tasked me with what seems to be such a simple idea...

2 replies Last reply on 1 Dec 2015 by
BrianGreen

Transfer worksheet

 Solved

Hello, How can I transfer an excel worksheet into another excel file. And when transferred I won't have to modify anything. Right now i'm cutting a...

3 replies Last reply on 1 Dec 2015 by
Gili

Will open office work on windows 10?

will Open Office work on Windows 10?

1 reply Last reply on 30 Nov 2015 by
xpcman

Download a file on pdf from email

Hello, I want to download a file on PDF from my email. Thanks Configuration: iPhone / Chrome 46.0.2490.76

1 reply Last reply on 30 Nov 2015 by
Ambucias

Problem when format date option

Hello, I have a date "17/07/15" and "01/07/2015" i want to change it to "July-15" format for all cases. I go through format option and select the op...

1 reply Last reply on 30 Nov 2015 by
TrowaD

Copy outlook email account settings

Hello, Is there a way to copy email account settings? I want to set up outlook to be able to send mail from the same account for several people ...

1 reply Last reply on 30 Nov 2015 by
WilliamB918

Excel and dates

Hello, I have three columns, for example 19-Nov-15 then 26- NOV-15, I want the third column to = the most recent date of the two +7. because I nee...

1 reply Last reply on 28 Nov 2015 by
RayH

Copy invoice dates to ledger

 Closed

@vcoolio Read your reply in an earlier post. copied it to my use, but this did not work. please help. I am copying a list of cell entries from invoi...

Last reply on 28 Nov 2015 by
vcoolio

How to convert number into words

Hello, pl give the solution

1 reply Last reply on 27 Nov 2015 by
Computertech

Transfer data from excel sheet to excel sheets.

Hello I have a table contains about 5000 rows and 4 columns. The columns are Date, Codes, Department and Amount. I entered one year's data in that ...

2 replies Last reply on 26 Nov 2015 by
vishnumethas55

Excel formula

 Solved

Hello, I'm trying to do a formula like: If value of celA3=sunday, then write dimanche Any help would be appreciated. thanks

3 replies Last reply on 25 Nov 2015 by
vcoolio

Scroll mouse in listbox

 Solved

Hello, I would like to know that How do I enable mouse scroll in listbox inside a userform. Thanks Configuration: Windows 7 / Chrome 46.0.24...

2 replies Last reply on 25 Nov 2015 by
smuneeb

Chance excel to pdf

How can it possible excel sheet to PDF? -- ifti

1 reply Last reply on 25 Nov 2015 by
rizvisa1

Date change to dd/mm/yyyy to dd/mm/yy

Hello, I Want to change date format dd/mm/yyyy to dd/mm/yy in MS Excel 2003 Please revert me urgently Configuration: Windows XP / Chrome 46.0...

1 reply Last reply on 25 Nov 2015 by
kieferschild

Calculation of age

Hello All, I have been trying to calculate the exact age of a person from two dates in Office 2007. In the first cell I have the current date and i...

11 replies Last reply on 25 Nov 2015 by
vcoolio

Create a summary table from a master table

Hello, I need a formula to create a summary table from a master table as below : Item Des. year ...

1 reply Last reply on 24 Nov 2015 by
rizvisa1

Get other cells value

Hello, I am stuck in a formula and I cannot solve it. Please I need help. I am making a survey on excel, and I need the result for a whole month ...

1 reply Last reply on 24 Nov 2015 by
rizvisa1

Compare excel sheet1 to sheet2 and highlight changes in sheet2

I have explained my query in screenshot. Somebody please help me get this resolved.....

1 reply Last reply on 24 Nov 2015 by
rizvisa1

Export data from one sheet to another

I need help. I have a form call Purchase Request from where I want transfer data to different fields in next sheet and then need to raise Purchase ...

3 replies Last reply on 24 Nov 2015 by
rizvisa1

Copying cells if criteria is met

Hello, I have multiple sheets with sheet 1 as the main sheet for entering data. A cell for entering a order number Cells for entering invoic...

1 reply Last reply on 24 Nov 2015 by
rizvisa1

Copy a 'template' sheet onto multiple other sheets

 Solved

Hello, i have been trying to create a sheet that creates new sheets from a list and i have been using the following macro to generate the sheets from ...

1 reply Last reply on 24 Nov 2015 by
rizvisa1

Averageif function using dates

Hi there. I'm trying to set up an average function based on dates entered in column a, for the data in column b. I want to use the data in b if the...

5 replies Last reply on 24 Nov 2015 by
RayH

Compare to columns in v lookup

Hello, hii i want to compare to columns in v lookup.. Pls advise ... Configuration: Windows 7 / Chrome 44.0.2403.155

14 replies Last reply on 24 Nov 2015 by
TrowaD

Add sheets to combobox

 Solved

Hello, Hi I would like to know that how to add sheets (which are exist in active workbook) in ComboBox used in Userform. Thanks Configurati...

5 replies Last reply on 24 Nov 2015 by
smuneeb
Results 2501 - 2550 out of a total of 12,266