If column B cell is a certain value then copy and paste the value to column A

		Microsoft Office Forums > Microsoft Excel > Excel Programming
If column B cell is a certain value then copy and paste the value to column A

FAQ

Thread Tools

Display Modes

12-01-2015, 07:10 PM

Graham Griggs Graham Griggs is offline

If column B cell is a certain value then copy and paste the value to column A

Windows 8

Office 2013

Novice

Join Date: Dec 2015

Posts: 11

Graham Griggs is on a distinguished road

I struggle to understand why you are trying to do something in VBA that is blindingly easy in Excel - see attached

The automatic detecetion of whether a cell has changed, and if so whether it matters are the essence of Excel - why try and re-write it?

If you do not know Excel, then it is a thousand times easier to learn than VBA

Attached Files

select T.xlsm (102.1 KB, 8 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy column 1 data into Column 3	ShailShin	Word VBA	1	06-18-2015 10:49 AM
Excel copy two numbers between specific column and paste in next sheet	visha_1984	Excel	1	12-26-2014 07:59 PM
how can i split a column of rows in half without copy and paste..	Lindseyfparker	Excel	2	04-25-2014 12:52 AM
keep each item/cell in column A associated with a group in column C	ht889	Excel	1	02-25-2014 12:36 PM
How can I delete the content of a cell in column if the cell value is more than 1000?	Learner7	Excel	2	06-27-2011 05:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:50 PM.