+ Reply to Thread
Results 1 to 7 of 7

code or formula? Copy data from 1 sheet to another

  1. #1
    Forum Contributor
    Join Date
    09-28-2016
    Location
    Seattle, washington
    MS-Off Ver
    2016
    Posts
    330

    code or formula? Copy data from 1 sheet to another

    Hello, please see my attached sheet - i'm trying to come up with the best way to move data from the Data sheet to the CFS Sheet based on entering the master number in cell C3 on the CFS Sheet ?? Then once moved the sheet would save as that master number on the desktop. Please let me know if i need to provide more information. Thank you for any and all help.
    Attached Files Attached Files
    Last edited by steve400243; 11-01-2016 at 08:02 PM. Reason: Updated

  2. #2
    Forum Contributor
    Join Date
    09-28-2016
    Location
    Seattle, washington
    MS-Off Ver
    2016
    Posts
    330

    Re: code or formula? Copy data from 1 sheet to another

    I'm Fairly new to Macros, Please let me know if I explained this clearly or not. I can provide more information if needed. Thank you.

  3. #3
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: code or formula? Copy data from 1 sheet to another

    No more merged cells for C3,D3,E3

    and then this will do, only by input in C3


    Please Login or Register  to view this content.
    Kind regards
    Leo
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    09-28-2016
    Location
    Seattle, washington
    MS-Off Ver
    2016
    Posts
    330

    Re: code or formula? Copy data from 1 sheet to another

    Quote Originally Posted by LeoTaxi View Post
    No more merged cells for C3,D3,E3

    and then this will do, only by input in C3


    Please Login or Register  to view this content.
    Kind regards
    Leo
    Thank you very much Leo, I appreciate your time and code! I will play with it more tomorrow, but this looks like what i need!

  5. #5
    Forum Contributor
    Join Date
    09-28-2016
    Location
    Seattle, washington
    MS-Off Ver
    2016
    Posts
    330

    Re: code or formula? Copy data from 1 sheet to another

    Quote Originally Posted by steve400243 View Post
    Thank you very much Leo, I appreciate your time and code! I will play with it more tomorrow, but this looks like what i need!
    Hello Leo, Thanks again, this work great! Is it easy to add more columns? As in the attached? I appreciate your time!
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: code or formula? Copy data from 1 sheet to another

    Please Login or Register  to view this content.
    Kind regards
    Leo

  7. #7
    Forum Contributor
    Join Date
    09-28-2016
    Location
    Seattle, washington
    MS-Off Ver
    2016
    Posts
    330

    Re: code or formula? Copy data from 1 sheet to another

    Quote Originally Posted by LeoTaxi View Post
    Please Login or Register  to view this content.
    Kind regards
    Leo
    Thank you Again Leo!!

+ 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] Formula to move data to another sheet
    By utahguy9384 in forum Excel General
    Replies: 8
    Last Post: 05-23-2014, 01:28 PM
  2. VBA code to move data from a entry sheet to a historical sheet by date
    By rlh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-17-2014, 07:15 PM
  3. Replies: 0
    Last Post: 05-10-2013, 08:08 AM
  4. VBA CODE to move rows from one sheet(1) to another sheet(2) based on data in cell
    By fozzieulo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2013, 02:43 PM
  5. Replies: 2
    Last Post: 10-09-2012, 04:40 PM
  6. Replies: 12
    Last Post: 07-25-2012, 09:35 AM
  7. Replies: 4
    Last Post: 01-25-2012, 03:18 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