View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bryan Loeper Bryan Loeper is offline
external usenet poster
 
Posts: 19
Default Copy Cells from WB to WB

Hey Dave! Long time no see!

Just to clarify, let's say you have a row in WB1!WS1 that has "a",
"b", "c", "d", and "e" in columns A:E and you're looking to copy "a",
"c", and "e" to WB2!WS2 columns A, C, and E, right?

I haven't found a way to yet (I can copy to A, B,and C), but I'm
working on it.

-Bryan

On May 18, 11:35 am, Dave Birley
wrote:
Ok, I know -- ol' Hercules only had to clean up those stables. I'm not so
sure he would have liked this one at all <g!

I have a pair of WBs. The WS columns are laid out differently, and don't
even have consistent names (one of them is rather fond of abbreviations).

I need to copy relevant data from one to the other, and would prefer to do
it one Row's worth at a time. So, for example if I want to copy something
from rngCell(1, 2) of one WB!WS to rngCell(varLastRow, 17) of the other
WB!WS, and at the same time copy rngCell(1, 15) to rng(varLastRow, 9), how do
I go about explaining that to Excel?

If I can get the core format for doing this, I can hack it into submission
for the real world.

TIA!!
--Dave
Temping with Staffmark
in Rock Hill, SC