+ Reply to Thread
Results 1 to 2 of 2

merging data in the background possible?

  1. 01-05-2020, 01:44 PM #1
    Mitama
    Mitama is offline
    Registered User
    Join Date
    12-12-2019
    Location
    Germany
    MS-Off Ver
    2010
    Posts
    2

    merging data in the background possible?

    Hello everybody and happy new year !

    I have a question about data merging:
    I copy several columns from different documents into the final document. I proceed column by column... Column A from Document 1 must be copied into column F etc etc. in Doc Final'.
    This works so far, but it is quite a chaos on the screen while Excel merges all data. Is there anything I can do to make it look better? For each column it activate one document and then the other one to insert it...

    I appreciate every tip!!
    Best regards
    Matma
    Reply With QuoteRegister To Reply
  2. 01-05-2020, 02:32 PM #2
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: merging data in the background possible?

    There could be several way to solved the issue
    A first one is to use
    Application.ScreenUpdating = False
    Your code
    Application.ScreenUpdating = True
    The more efficient to answer you is to attach a short Excel sample WITH the macro you are using.
    - Battle without fear gives no glory - Just try
    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. Help adjusting macro from merging worksheets to pulling data from workbooks and merging.
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2017, 09:20 PM
  2. [SOLVED] white background where data is
    By stribor40 in forum Excel General
    Replies: 1
    Last Post: 09-01-2014, 12:40 PM
  3. Move data to background
    By no.18shirt in forum Excel General
    Replies: 4
    Last Post: 04-08-2013, 04:50 AM
  4. Merging: displaying which sheet data comes from when merging sheets
    By zed commander in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-12-2012, 12:20 PM
  5. Excel 2007 : Search data. If found, return data and color original cell background
    By tjbvo in forum Excel General
    Replies: 0
    Last Post: 01-14-2012, 02:13 AM
  6. Data Validation would like to highlight background when invalid data is present
    By moto485 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2011, 09:20 PM
  7. Hidden Background Data File
    By PhilSM in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2009, 04:19 PM

Tags for this Thread

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