Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Help on copy and paste

  Asked By: Egidius    Date: Feb 13    Category: MS Office    Views: 860
  

Really need your help to solve my problems, a code that can do something like
below:

1. If there is are specific words (say a "Cat" at B50 and B52) then the macro
will Copy a selected columns/Rows (A1, B20 and AD51) from this sheet (of
Workbook A) to a different Workbook (Workbook B) and into a specific sheet, say
in a sheet AB.

2. When new data is being copied into this new workbook; it will continue being
pasted into a new row below the old ones (with one row spacing).

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Kim Coleman     Answered On: Feb 13

Ok to be simplified as below :



How can I copy  a range (values only) in a hidden sheet  from an open
workbook to a closed file and on specific  sheet?


 
Didn't find what you were looking for? Find more on Help on copy and paste Or get search suggestion and latest updates.




Tagged: