The discussions

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

3 replies 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

Conditional formatting on multiple criteria

 Solved

hi, i am trying to create an excel vba code for creating a conditional formatting where i want to insert colour on the basis of multiple rules. i am ...

5 replies Last reply on 23 Nov 2015 by
TrowaD

Copy data from another sheet if the condition is met

Hello, Can you help me how can I create macro that will copy the data from one sheet to another sheet in the same file? Wherein if the Posting Acc...

1 reply Last reply on 23 Nov 2015 by
vcoolio

Transfer data if....

Hi, I am in the process of building a database for injury management (I am a Sport Scientist). I have a master sheet which is basically a monthly ...

3 replies Last reply on 23 Nov 2015 by
vcoolio

How to convert a numeric value into english words in excel 2007

Hello, Configuration: Windows XP / Chrome 43.0.2357.134 Sir, How to convert a numeric value into English words in Excel 2007 in software

1 reply Last reply on 22 Nov 2015 by
BashirYazbik

Outlook.com

Hello, I have a email that I consider as voluntary work. Address is: ***@*** I would like to have a personal email that will not be affiliated ...

1 reply Last reply on 22 Nov 2015 by
Ambucias

Comparing columns in excel 2010

 Solved

Hello all: I have an excel spreadsheet with 95 columns. I want to compare column 1 to column 95 and highlight in column 1 any line item that is mi...

2 replies Last reply on 22 Nov 2015 by
laulou95

Word icon

Hello, My word icon desapered from desktop how do I recover it?? Configuration: Windows / Chrome 46.0.2490.86

1 reply Last reply on 21 Nov 2015 by
BrianGreen

Set rows height also exception in range

 Solved

Hello, I would like to request that rows from 10 to 40 their height will be Set to 12.75 but exception rows 11, 16, 21, 26, 31, 36 height will be...

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