Results 1 to 7 of 7

Duplicating Sheets, freezing system, and questions about VBA code in workbook

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-01-2017
    Location
    Las Vegas, NV
    MS-Off Ver
    Office 2013
    Posts
    148

    Duplicating Sheets, freezing system, and questions about VBA code in workbook

    Hopefully this is the right section.

    Background:
    I am building a spreadsheet that helps analyze game flash cards and player decisions. My first sheet is where all the data is entered and then second sheet is basically a summary of the first sheet.

    I have this set up pretty much exactly how I want it to analyze one deck, however I want to make 9 copies of these two sheets since I need to analyze 10 decks.

    I have 2 questions/issues.

    1) my two sheets have several conditional formatting rules that connect the two sheets. Like if Sheet 1, A1 has a specific value, Sheet 2, A1 will be hidden or highlighted. I also have a couple simple macros saved in the project. My question is, if I create 9 more copies of these two sheets, will the formulas, macros or conditional formats still work for each pair of sheets or will they still be associated with the first pair of sheets, meaning I will have to go through every conditional format and every macro and change them for the specific pair of sheets.

    2) THIS IS MY MAIN QUESTION. I cannot duplicate the two sheets. Specifically the first one, titled "Deck 1 Input". Its like it is thinking and just never advances. I have let it run for several minutes. Nothing I do seems to work around this issue and I eventually have to close the entire program. Anybody have any ideas?

    I've tried to attach the file to this post but it continues to fail. Maybe its too big. The file is 3.73 MB (3,919,900 bytes). Thanks for your help.
    Last edited by AliGW; 01-20-2022 at 06:02 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-10-2019, 05:05 AM
  2. [SOLVED] Duplicate Template sheet based on names in List sheet
    By Ravana in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2018, 01:35 PM
  3. [SOLVED] VBA - Macro issue copy/paste line other sheet + duplicate current sheet
    By vcourbiere in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-17-2014, 12:06 PM
  4. Preventing duplicate entry of a row in Sheet 2 while copying selected rows from Sheet 1
    By Pavan Renjal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-31-2012, 04:27 PM
  5. Count the number of duplicates in a sheet, report the duplicate cells to a new sheet.
    By SamPetroda in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-25-2012, 09:48 AM
  6. Search column a for duplicate data and copy entire row to duplicate sheet
    By crazyAMP in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2012, 08:21 PM
  7. Replies: 2
    Last Post: 12-22-2008, 02:01 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