Results 1 to 12 of 12

Need to copy the data into new sheet with cell based file name.

Threaded View

  1. 06-24-2018, 02:35 AM #1
    anwitha
    anwitha is offline
    Forum Contributor
    Join Date
    10-16-2010
    Location
    bangalore
    MS-Off Ver
    Excel 2019
    Posts
    288

    Need to copy the data into new sheet with cell based file name.

    Hi Experts,

    Need to get the below result through VBA code based on the attached sample workbook.

    1. I need to copy the entire data from sheet1 into new sheet with paste special values without blanks.
    2. Sheet needs to be saved on the desktop irrespecive of any user with file name based on the sheet2 cell E1.

    Regards,
    Anwitha
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Copy row data from one sheet to another based on cell input
    By sludeking in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-17-2018, 12:48 PM
  2. [SOLVED] Copy Data to Sheets (Sheet name based on value from Cell)
    By Andrew.Trevayne in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2017, 09:18 AM
  3. [SOLVED] Copy paste data one to multiple sheet based on cell value to sheet name
    By kannan1847 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2015, 12:54 AM
  4. [SOLVED] Need to Copy cells data to a new sheet based on value of another cell
    By clintandcaden in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-14-2012, 05:28 PM
  5. [SOLVED] Macro to Copy Data from one Sheet A to Sheet B based on value in cell on sheet A
    By scass in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2012, 07:21 PM
  6. Seach in folder and copy data from file based on sheet names in master workbook
    By Hassų in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-06-2012, 09:25 AM
  7. How to copy data from a sheet based on a cell value?
    By Bill Williams in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-27-2011, 01:27 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