Copying Records

The UK's most regular instructor-led training courses.
Training information: excel consultancy · Excel/courses/london · Microsoft Office VBA training

Resolved · High Priority · Version 2007

2 posts

ReplyWed 10 Feb 2010, 16:06Delegate Lee said...

Lee has attended:
Excel VBA Intro Intermediate course

Copying Records

Is it possible for the content of a cell to be copied if the value of the cell is greater than zero ?

we created a code that had the following to copy the data in the cell if the salesperson name matched strName

If Sheets("Total Sales").Range("a10").Cells(introwcount, 10).Value = strName Then

Can the last bit be changed to somehting like this

If Sheets("Total Sales").Range("a10").Cells(introwcount, 10).Value = > 0

to copy all the content when the value of the cell is greater than zero

The code i have given below still copies all records even when there is a "0" in the reference cell.

Thanks
Lee

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2007	Mon 2 Aug 2010	Southwark	3		£240	£245	£245
2003	Thu 5 Aug 2010	Southwark	4		£240	£245	£245
2010	Fri 6 Aug 2010	Bloomsbury	0	FULL			£299
2007	Tue 10 Aug 2010	Bloomsbury	0	FULL			£245
2003	Tue 10 Aug 2010	Limehouse	5		£235	£240	£245
2007	Fri 13 Aug 2010	Limehouse	8		£229	£234	£245
Full Schedule: See all 134 Excel Advanced course dates. Bookings currently available until 28th September 2011.

825 posts

ReplyFri 12 Feb 2010, 16:39Trainer Stephen said...

RE: Copying Records

Hi Lee

Thanks for your question

your code

If Sheets("Total Sales").Range("a10").Cells(introwcount, 10).Value = > 0

Is copying it if it is greater than OR equal to 0

Try

If Sheets("Total Sales").Range("a10").Cells(introwcount, 10).Value > 0

(without the = )

Instead

Regards

Stephen

· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Business Forecasting With Microsoft Excel
· The Pursuit of Excellence
· Using Excel In Any Condition
· Using The Drawing Toolbar In Excel

Please browse our web site to find out more about
excel consultancy and other Microsoft training courses.