LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 58
Default Copy down 1 column to the left

I have the following code that:

1. finds a cell Ex: B13
2. copies down from that cell Ex: B13:B15 (original data)
3. moves left one cell and pastes down Ex: A13:A15

The code I have then copies down from B13 to B15 and deletes the data in the
cell at the top (B13). This procedure is down several time in the document
and the ranges change each day. What I want it to do is copy down from
A13:A15, one column over from the original column of data. Anyone know how to
fix this??? Thanks in advance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
subtract column right from column left in excel? Muffin[_2_] New Users to Excel 2 June 17th 09 02:55 PM
how to copy down formulars into same column by a row left to righ Holly Excel Discussion (Misc queries) 5 April 3rd 07 10:59 PM
Column labels run right to left, not left to right tmassey Excel Discussion (Misc queries) 1 November 10th 06 11:03 AM
VB copy paste column data to another left to right sheet across sh baz Excel Programming 2 April 23rd 06 09:37 AM
Right column doesn't change when sorting left column. nohope Excel Discussion (Misc queries) 2 July 19th 05 03:27 PM


All times are GMT +1. The time now is 02:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"