+ Reply to Thread
Results 1 to 11 of 11

Transfer Data from one sheet to another

  1. #1
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    265

    Transfer Data from one sheet to another

    Hi Guys,

    What i am trying to achieve is move the data from Input sheet of the workbook to Output sheet. Sample file attached.

    Input sheet is an entry sheet for data entry after selecting Customer in Cell A2
    Output sheet is the master data to store the data entered in input sheet every time user click on append command button. Data to be appended from last used cell.

    I tried with VBA code but no luck, may because of De - normalized data.

    Any suggestion would help
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    23,616

    Re: Transfer Data from one sheet to another

    As you hint at, you should normalise your data.
    With a proper database you'll then be able to use Pivot tables to do all the analysis you could conceivably want, and at the same time avoid VBA macros and even Excel formulae.

    So create an database table that has columns for

    Date
    Store
    Variant
    Fruit/Vegetable
    Yes/No

    and populate each row with a data record.

    If necessary create an input area which captures that information and have a macro that simply copies a new record to the next row in the database.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

    Forum Rules Updated September 2018. Please read them by clicking here.

  3. #3
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    265

    Re: Transfer Data from one sheet to another

    Hi,

    That is the reason I am creating a Master data to store and normalise the data. The first tab - input sheet is a data entry sheet and it an standard layout hence cannot change it.

    If you see the second tab- output sheet. The sample output is in a normalised way.

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    8,994

    Re: Transfer Data from one sheet to another

    Please give this a try...
    In the attached, click on the button called "Copy To Master" on Input Sheet to run the code and see if you get the desired output on Output Sheet.


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  5. #5
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    265

    Re: Transfer Data from one sheet to another

    This worked perfectly, thank you so much.
    One more question, Can it append the data to the last unused cell in the output sheet after each time the user enters fresh data in input sheet

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    8,994

    Re: Transfer Data from one sheet to another

    You're welcome Biplab! Glad it worked as desired.
    Yes. You should have tried that before asking that question.

    If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

    You may also say thanks to those who have put their time and efforts to help you in this forum by clicking the Add Reputation link under their posts, another way to say thanks.

  7. #7
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    265

    Re: Transfer Data from one sheet to another

    Hi Sktneer,

    Thank you so much, it worked properly. Now one more leap if you could help me out here, i tried but could not find a way out. What i need is to Retrieve the Saved Data in Mater data Sheet when selection of Store in Cell A2 and per Quater and week number. File attached

    Any suggestion would help
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    265

    Re: Transfer Data from one sheet to another

    Any suggestion please?

  9. #9
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    265

    Re: Transfer Data from one sheet to another

    Hi Experts,

    Any lead would be so helpful. I really need to close this. I can achieve this through formulas but looking for VBA alternative

  10. #10
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    265

    Re: Transfer Data from one sheet to another

    Hello All,

    Any input please, need to close this

  11. #11
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    265

    Re: Transfer Data from one sheet to another

    I tried this code, but failed.p;ease help
    Please Login or Register  to view this content.
    Last edited by Biplab1985; 03-21-2018 at 05:30 PM.

+ 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