Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Tye Thompson   on Mar 04 In MS Office Category.

  
Question Answered By: Cesara Fernandez   on Mar 04

OK, first of all, turning the cell & font white will NOT keep it from printing.
Your printer doesn't print WHITE, so it'll default to black.

Second... It's VERY possible to just copy  certain cells.

You said "but only copy "H","HD" or "S""..
that has absolutely NO meaning for me.
Are you saying that you're wanting to copy rows from each of the sheets,
but only if they have a specific value in a specific column?
Is there a limit to the number of rows in each sheet  (I suspect that there is,
but...)
It's really fairly simple, but I would NOT recommend using copy/paste.
It's VERY CPU intensive.
If you use something like:
sheets("Balance").cells(ROWNUM,ColNo) = sheets(MonthNo).cells(r,c)
in a series of nested loops, it would run MUCH faster.


If you can give me some more info, or even send me the file, I can see what I
can do.

Share: 

 

This Question has 5 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on copy a range of cells to another sheet Or get search suggestion and latest updates.


Tagged: