+ Reply to Thread
Results 1 to 3 of 3

Problem using a macro from one workbook for a similar purpose in another workbook

  1. #1
    Registered User
    Join Date
    07-24-2013
    Location
    Boston, MA
    MS-Off Ver
    Excel 2010
    Posts
    32

    Problem using a macro from one workbook for a similar purpose in another workbook

    Hello. A few days ago, someone assisted me in creating a macro that enabled me to copy certain cells from one sheet to another when a check box was ticked. Works like a charm.

    I have another workbook where I want to do something similar. I thought I could easily substitute spreadsheet names and cell ranges to make the same macro work here. But I've not been successful. Attached is a shell of the workbook I'm working on now. Check boxes are there. This time I have several sheets and want specific cells from any checked rows on any of the sheets to move to the "programs requested" sheet at the end. I tried doing it with the first sheet (Brockton) as a test and had no luck. Here is the language below....Getting run time errors, among others. FYI, the cells I would like moved over when checked are A,B,D,N,P,R and S.

    Could someone assist me?
    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,663

    Re: Problem using a macro from one workbook for a similar purpose in another workbook

    How is this post different from this one?
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    07-24-2013
    Location
    Boston, MA
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Problem using a macro from one workbook for a similar purpose in another workbook

    I'm sorry. I guess I do not understand how I have not complied with rule number 3. I took at the code language that I pasted in the original thread, thinking that would take care of my infraction. I apologize for my lack of savy in this arena.
    Take care.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problem using a macro from one workbook for a smilar purpose in another workbook
    By SMcuthbert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2013, 08:10 PM
  2. [SOLVED] Macro to check if folder contains excel files with names similar to This Workbook
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-17-2013, 07:54 PM
  3. Replies: 3
    Last Post: 05-05-2012, 11:43 AM
  4. how to update a similar sheet in a different workbook without opening that workbook
    By hattisaeed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2011, 02:05 AM
  5. Replies: 11
    Last Post: 03-07-2006, 08:40 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1