+ Reply to Thread
Results 1 to 10 of 10

Macro to move data from one sheet to another and separate 1 cell into 2

  1. #1
    Registered User
    Join Date
    08-20-2012
    Location
    Utah
    MS-Off Ver
    Excel 2010
    Posts
    45

    Macro to move data from one sheet to another and separate 1 cell into 2

    OK, I don't know how complex this is going to be but here goes. I have a worksheet that has time clock information. I also have a resource on the web to see some information and even export it.


    In the exported data it looks as follows:

    A1 contains an individuals name
    B1 says times i.e. "8am to 5pm"


    I would like a macro that takes the data from A1 and moves it to another worksheet in the B4 position down, and take the times from B1 and move the first time to the C4 position and the last time to H4.

    If this isn't complicated enough, I need this to be in military time. Any help is greatly appreciated.

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Macro to move data from one sheet to another and separate 1 cell into 2

    Not entirely sure of your requirements, this is my assumption.

    Please Login or Register  to view this content.
    多么想要告诉你 我好喜欢你

  3. #3
    Registered User
    Join Date
    08-20-2012
    Location
    Utah
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: Macro to move data from one sheet to another and separate 1 cell into 2

    This is working to a certain extent, However what I have in A1 (from exported data) is being copied to B42 (last line in the sheet) I would like it to start at B4 (first line in the sheet).

  4. #4
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Macro to move data from one sheet to another and separate 1 cell into 2

    Try this

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-20-2012
    Location
    Utah
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: Macro to move data from one sheet to another and separate 1 cell into 2

    That's just about it, only thing now is it only takes the data from A1 in the exported data sheet. I need it to take all of it (usually A1 through about A35 or so) and put it into the other sheet.

  6. #6
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Macro to move data from one sheet to another and separate 1 cell into 2

    That's totally different from what you have described in the first post. Try this

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    08-20-2012
    Location
    Utah
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: Macro to move data from one sheet to another and separate 1 cell into 2

    Sorry for not explaining myself well the first time. This is exactly what I needed. Thank you so much!!

  8. #8
    Registered User
    Join Date
    08-20-2012
    Location
    Utah
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: Macro to move data from one sheet to another and separate 1 cell into 2

    Just noticed this is only copying the first 10 rows of data. How would I make this copy any of the data in the exported data sheet?

  9. #9
    Registered User
    Join Date
    08-20-2012
    Location
    Utah
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: Macro to move data from one sheet to another and separate 1 cell into 2

    I have modified this only slightly, but I'm still not seeing anything past 10 rows on the destination sheet after running the macro. Here is the code:

    Please Login or Register  to view this content.

  10. #10
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Macro to move data from one sheet to another and separate 1 cell into 2

    It should be getting everything unless your downloaded data is segmented. Shown an example of your downloaded data/file.

+ 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] To move Data rows to columns against one cell so can write separate SQL insert statments
    By hadster016 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2014, 09:52 AM
  2. Change cell value that has data validation from list in a separate sheet with macro?
    By jimmyjackjoejames in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2013, 11:31 AM
  3. Macro edit to move data to TWO separate sheets
    By dlab85 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-16-2012, 01:00 PM
  4. Replies: 2
    Last Post: 10-09-2012, 04:40 PM
  5. Replies: 7
    Last Post: 09-07-2011, 02:30 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