+ Reply to Thread
Results 1 to 10 of 10

Copies formats for more than sheet

  1. #1
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Copies formats for more than sheet

    my greetings to all
    I have this code to transfer data from the data source sheet to two sheets ( excel & forum) depending on two conditions
    Is there a way to complete the code shown in this example
    Please I want to copy all the formats of the row when grabbed into "excel sheet" & "forum sheet"
    Thank you very much for the help
    Attached Files Attached Files
    Last edited by salmasaied; 01-20-2017 at 06:41 PM.

  2. #2
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Copies formats for more than sheet

    Please help in this thread

  3. #3
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Copies formats for more than sheet

    Hi salmasaied,

    Try the following macro which is included in the attached file. The columns in the destination sheets are the same widths as the columns in the source sheet. Some of the columns in the source sheet are too narrow.

    In ordinary code module ModLewis:
    Please Login or Register  to view this content.
    Lewis
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Copies formats for more than sheet

    Welcome Mr. LJMetzger
    Thank you for your interest
    Dear Friend
    The original file contains more than 30,000 row
    I've tested the attached file, but very, very slowly
    I think that things will become easier and faster using arrays
    Given the vast amount of data *** Please Is there a way to solve this problem
    Thank you very very much for the help
    Last edited by salmasaied; 01-23-2017 at 10:30 AM.

  5. #5
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Copies formats for more than sheet

    Please help in this thread

  6. #6
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Copies formats for more than sheet

    Please help in this thread

  7. #7
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Copies formats for more than sheet

    Is there anything unclear resolve this problem

  8. #8
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Copies formats for more than sheet

    Please help in this thread

  9. #9
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Copies formats for more than sheet

    Hi salmasaied,

    I apologize for the slow response. I did not forget you. I was very busy.

    Try the following macros included in the attached file. The original software took 2 seconds for 200 data rows on my 10 year old computer. This software takes 11 seconds for 40,000 data rows. I don't think I can improve performance on what I've done.

    Instead of arrays, I took advantage of the Excel 'AutoFilter' capability. However, their was a limitation, because 'AutoFilter' does not like 'Merged Cells'. I removed the 'Merged Cells' and double the height of row 6, and made the height of row 7 ZERO. The look and feel of the Workbook remains the same. I changed to orientation of the sheets to 'Left to Right'. I am not used to 'Right to Left', and it gave me a headache.

    In an ordinary code module:
    Please Login or Register  to view this content.
    Lewis
    Attached Files Attached Files
    Last edited by LJMetzger; 02-04-2017 at 05:46 PM.

  10. #10
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    246

    Re: Copies formats for more than sheet

    Welcome Mr. LJMetzger
    I can not believe myself
    After these days that have passed and you Remember me
    Let the solution aside .... and let me tell you...you're the best brother and best friend
    Thank you so much for your love
    Thank you very much for this wonderful solution
    May Allah reward you
    Last edited by salmasaied; 02-04-2017 at 07:08 PM.

+ 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. [SOLVED] Need macros that creates new rows and copies matching info from sheet 1 to Sheet 2
    By vpan in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-13-2016, 02:49 PM
  2. Help with buggy code, copies shape in one sheet and pastes to anchor cell in other sheet
    By Bud Wilkinson in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-02-2016, 08:39 PM
  3. Replies: 2
    Last Post: 05-01-2013, 12:26 PM
  4. Copy sheet to another WB and macro copies that data to last row of master sheet
    By nickmax1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-19-2013, 06:31 PM
  5. [SOLVED] Insert row that copies formulas and formats from another row
    By jas001 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-27-2012, 01:08 PM
  6. Replies: 6
    Last Post: 07-25-2012, 07:55 AM
  7. Looping through worksheets to copy/paste to new sheet - last sheet never copies
    By lifeboat in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-10-2011, 01:53 PM

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