Macro to paste data to a new column if previous column has data

Posted to microsoft.public.excel.programming

Neil[_29_] Neil[_29_] is offline

external usenet poster

Posts: 7

Macro to paste data to a new column if previous column has data

Hello,

I have a range of data in column A. I want to be able to run a macro
and paste it into another column (C). Then later when i make a change
to the data in column A, i want to be able to paste it into the next
available column (in this particular example it would be column D).

Any help would be much appreciated.

Thanks
Neil

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Based on data in previous column - sum of values in next column	Beena K	Excel Worksheet Functions	1	April 7th 09 07:23 PM
Shortcut to select column with data in previous column	TJAC	Excel Discussion (Misc queries)	1	July 10th 07 06:12 PM
Display column when previous column contains data	[email protected]	Excel Programming	1	January 3rd 07 03:01 PM
Copying a formula in a blank column as far as data in previous column	basildon	Excel Programming	1	December 16th 05 03:32 PM
Macro that will autofill a column with data, up to the last row of data in previous c	Max Velocity	Excel Programming	4	November 27th 03 10:34 AM

All times are GMT +1. The time now is 08:40 AM.

Menu

About Us