+ Reply to Thread
Results 1 to 9 of 9

How can Copy the same format as the from source data to tow sheets

  1. 12-31-2016, 01:34 PM #1
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    256

    How can Copy the same format as the from source data to tow sheets

    good greeting
    I have this code to transfer data from the data source sheet to two sheets ( excel & forum) depending on two conditions
    I have tried to make some additions to copy formatting from the data source to the two papers but to no avail
    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-05-2017 at 07:46 AM.
    Reply With QuoteRegister To Reply
  2. 12-31-2016, 02:10 PM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Copy the same format as the source

    Have you tried using an Advanced Data filter?

    You will first need to unmerge rows 6&7 on the Data Source and ensure that every column has a label in Row 7. Always try not to merge cells they just cause too much trouble with all sorts of functionality

    You haven't said what the selection criteria are, but whatever they are you'll need to create a criteria range that contains the values you want to filter.
    If its an OR type filter then each criteria value needs to be on a separate row.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  3. 12-31-2016, 07:35 PM #3
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    256

    How can Copy the same format as the from source data to tow sheets

    Welcome and hello to you Mr.Richard Buttrey
    Thanks a lot for replies
    I've tried but I can not make it happen
    As for the merged cells it is important for the workbook to contain columns of pounds and other piaster
    I hope to find a solution to this issue because I am convinced that there is a solution
    Thank you very much for the help
    Kind regards
    Last edited by salmasaied; 01-02-2017 at 08:10 AM.
    Reply With QuoteRegister To Reply
  4. 01-01-2017, 02:09 PM #4
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    256

    How can Copy the same format as the from source data to tow sheets

    good greeting
    We have learned the word here not impossible
    Thank you very much for the help
    Last edited by salmasaied; 01-02-2017 at 08:10 AM.
    Reply With QuoteRegister To Reply
  5. 01-01-2017, 02:10 PM #5
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    256

    How can Copy the same format as the from source data to tow sheets

    Is it possible to help
    Last edited by salmasaied; 01-02-2017 at 08:09 AM.
    Reply With QuoteRegister To Reply
  6. 01-02-2017, 08:58 AM #6
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    256

    Re: How can Copy the same format as the from source data to tow sheets

    Is there something unclear
    Reply With QuoteRegister To Reply
  7. 01-02-2017, 09:05 PM #7
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    256

    Re: How can Copy the same format as the from source data to tow sheets

    Is it possible to assist in this issue
    I have tried in many ways to no avail
    Last edited by salmasaied; 01-02-2017 at 09:08 PM.
    Reply With QuoteRegister To Reply
  8. 01-06-2017, 11:40 AM #8
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    256

    Re: How can Copy the same format as the from source data to tow sheets

    Please any help
    Reply With QuoteRegister To Reply
  9. 02-04-2017, 08:03 PM #9
    salmasaied
    salmasaied is offline
    Forum Contributor
    Join Date
    10-23-2015
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    256

    Re: How can Copy the same format as the from source data to tow sheets

    Thank you very much for the help
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. how to copy the exact data source format as is.
    By dedark05 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-18-2016, 11:56 PM
  2. vba to copy data from source and paste it in output in a specified format
    By Sendilo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2016, 11:12 PM
  3. [SOLVED] Copy the same format as the source using arrays
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-03-2015, 07:33 AM
  4. Copy and past from Excel to Word - "keep source format" doesn't
    By snappytim in forum Excel General
    Replies: 0
    Last Post: 10-29-2014, 09:56 PM
  5. copy data from one sheet to annother, format it; Update to refect changes on source sheet
    By simplificated in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2013, 03:45 PM
  6. VBA Code to copy the format from source data to extracted report
    By rav4u_tom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2010, 03:53 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