Results 1 to 8 of 8

Using VBA to automate copy/paste on new Sheet

Threaded View

  1. 12-09-2016, 05:59 PM #6
    kev_
    kev_ is offline
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Using VBA to automate copy/paste on new Sheet

    Does this summarise everything correctly:

    - copy Range("AR3:BB28") from each sheet in turn
    - paste values to sheet "Gail"
    - "Gail" headings are in Row1 and the data starts in A2
    - remove any rows where Units = 0 (in "Gail")
    - put all text into uppercase (in "Gail")

    Where (in relation to other sheets) should "Gail" be placed?
    Last edited by kev_; 12-09-2016 at 06:33 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automate repititive copy and paste
    By Raury in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2014, 12:53 PM
  2. Automate wksht on cell change: formulas to values, copy / paste rows, delete sheet
    By rls231 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-12-2013, 01:35 PM
  3. How to automate copy paste
    By alyasch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2013, 09:36 AM
  4. Automate copy and paste and copy and paste back to excel
    By Bmw318be in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2013, 05:42 AM
  5. Automate copy and paste and copy and paste back to excel
    By Bmw318be in forum Access Tables & Databases
    Replies: 0
    Last Post: 02-23-2013, 05:42 AM
  6. Automate a Large Copy and Paste Task
    By The Cardinal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2009, 03:57 AM
  7. Automate Cut/Copy/Paste from Excel Cells
    By Do it the Easy Way in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2006, 12:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1