+ Reply to Thread
Results 1 to 9 of 9

Pulling info out of an old layout

  1. 04-05-2010, 11:12 PM #1
    Befuddled
    Befuddled is offline
    Forum Contributor
    Join Date
    09-22-2009
    Location
    Henderson, KY
    MS-Off Ver
    Excel 2007
    Posts
    152

    Pulling info out of an old layout

    Is there a way to convert one layout of a sheet to another layout.
    What I have is:
    a format that has info in A8:L13 (this is one entry)
    info in A14:L19 (another entry)
    Etc.....
    I have a new format that has all of each entry in the same row, so I can use it as a table.
    I can fiddle with the info(to make it match my new format) once I get it out, I just need to pull all of that data out without physically re-entering it.
    Is this Possible?
    Reply With QuoteRegister To Reply
  2. 04-05-2010, 11:22 PM #2
    stanleydgromjr
    stanleydgromjr is offline
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Pulling info out of an old layout

    Befuddled,

    Can we see your workbook?

    Click on the New Post button, then scroll down and see Manage Attachments.
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
    Reply With QuoteRegister To Reply
  3. 04-06-2010, 04:05 AM #3
    Befuddled
    Befuddled is offline
    Forum Contributor
    Join Date
    09-22-2009
    Location
    Henderson, KY
    MS-Off Ver
    Excel 2007
    Posts
    152

    Re: Pulling info out of an old layout

    Here is one Month's workbook.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 04-06-2010, 08:43 AM #4
    stanleydgromjr
    stanleydgromjr is offline
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Pulling info out of an old layout

    Befuddled,

    Thanks for the workbook.

    There is no example in your workbook with the new layout.

    Please manually copy/enter the new format beginning in column N in worksheet 10-1-08 1st.

    Then post the updated workbook.
    Last edited by stanleydgromjr; 04-06-2010 at 08:48 AM.
    Reply With QuoteRegister To Reply
  5. 04-08-2010, 12:48 AM #5
    Befuddled
    Befuddled is offline
    Forum Contributor
    Join Date
    09-22-2009
    Location
    Henderson, KY
    MS-Off Ver
    Excel 2007
    Posts
    152

    Re: Pulling info out of an old layout

    I added an example of the new layout starting at N8 in the "10-01-08 1st" sheet
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 04-08-2010, 03:34 PM #6
    stanleydgromjr
    stanleydgromjr is offline
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Pulling info out of an old layout

    Befuddled,

    Thanks for the updated workbook.

    Having a little problem with understanding where the information in range N9:AC9 is coming from.

    Can you redue the result on worksheet "10-1-08 1st", so that the information in range N9:AC9 is based on the first grouped entry on worksheet "10-1-08 1st".
    Reply With QuoteRegister To Reply
  7. 04-08-2010, 09:00 PM #7
    Befuddled
    Befuddled is offline
    Forum Contributor
    Join Date
    09-22-2009
    Location
    Henderson, KY
    MS-Off Ver
    Excel 2007
    Posts
    152

    Re: Pulling info out of an old layout

    I adjusted the example. Each item is linked to where it comes from in the original info
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 04-09-2010, 10:26 AM #8
    stanleydgromjr
    stanleydgromjr is offline
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Pulling info out of an old layout

    Befuddled,

    Detach/open workbook "Create New Layout - Befuddled - SDG.xlsm" and run macro "NewLayout" on any active worksheet.

    The macro will not run on worksheets "1st shift form", "2nd shift form", or "Instructions".
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 04-10-2010, 12:06 AM #9
    Befuddled
    Befuddled is offline
    Forum Contributor
    Join Date
    09-22-2009
    Location
    Henderson, KY
    MS-Off Ver
    Excel 2007
    Posts
    152

    Re: Pulling info out of an old layout

    I will try it, thanks for putting your time into this for me.
    Hopefully I will be able to trudge through you code and learn enough to write the same thing for a couple other projects I need to get to.
    Thanks
    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)

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