+ Reply to Thread
Results 1 to 3 of 3

Copying unprotected data from one sheet of workbook to another workbook

  1. #1
    Registered User
    Join Date
    02-04-2013
    Location
    mumbai
    MS-Off Ver
    Excel 2003
    Posts
    2

    Copying unprotected data from one sheet of workbook to another workbook

    Hi
    I have to a workbook with 31 sheets
    I wish to paste the unprotected data from each sheet to another workbook in the same particular named sheet and same cell as the previous work book

    I cannot use the copy sheet in excel as the formats of the sheets are different giving me different out put through formulae

    I wish to delete the previous sheet once data is trasfered
    please assist me with a macro to do so.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Copying unprotected data from one sheet of workbook to another workbook

    So, you have two identically constructed workbooks.

    The old one has some data (not formulas) in certain unlocked cells on each of 31 separate sheets.

    In the new wb you would like that same data (not formulas) to be transferred to the sheets of the same name and into the same cell addresses, on all 31 sheets.

    Is this correct?
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    02-04-2013
    Location
    mumbai
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Copying unprotected data from one sheet of workbook to another workbook

    I have attached excel sheet for your reference.

    I need to copy data from Dinning Hall May 13 to Dinning Hall format Ammd 27.06.2013 for all days.

    There has been a change in certain formulas. Hence no folmulaes (locked cell data ) has to be trans fed only data in unprotected cell has to be transferred to the new ammeded format workbook.
    A new column has been added in AJ27called Total Cups as compared to the previous sheet where in AJ 27 has discount.

    Hence the discount appearing in AJ27:AJ39 should appear in AK27:AK39 rest all data in unprotected cell should be transferred in ditto cells in the new work book.

    Your quick assistance will be greatly appreciated as I have a presentation and have been loosing a lot of time trying to copy data manually for a quarter

    Thanking you
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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