+ Reply to Thread
Results 1 to 5 of 5

Copy Paste data based on Month Names

  1. #1
    Forum Contributor
    Join Date
    12-19-2012
    Location
    Bengaluru
    MS-Off Ver
    Excel 2013
    Posts
    108

    Copy Paste data based on Month Names

    Hi all,

    I need a help regarding the below problem which i'm facing.

    I work for a warehousing company where in we maintain the stock details in Excel. There would be columns stating the stock type, code, opening stock, closing stock and approved stock count for a particular stock type. The opening stock of the current month would be the closing stock of previous month. It would be entered manually in the beginning of every month and this is taking a lot of time.

    I'm trying to automate the same through Macros by creating a table in the same sheet and using the drop down to select a month. The closing stock of the current month should go into the respective month depending on the stock type and should be the opening stock for the next month.

    I tried a few ways but i couldn't get the desired results.

    Can some one help on this.

    Please see the attached file for easy understanding of the problem.

    Thanks in advance.
    Attached Files Attached Files
    Click on the star * if some1 helped you.

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Copy Paste data based on Month Names

    See how this works for you.
    Attached Files Attached Files
    Last edited by skywriter; 08-25-2015 at 10:29 PM.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Forum Contributor
    Join Date
    12-19-2012
    Location
    Bengaluru
    MS-Off Ver
    Excel 2013
    Posts
    108

    Re: Copy Paste data based on Month Names

    Hi Skywriter,

    Thank u for your time in providing with the macro.

    However, it serves the purpose partially. It copied the data to the 2nd table based on the month selected. But, The opening stock remains same irrespective of the month i select.

    Also, I need the Macro to pull the data depending on the month which is selected from the drop down. If at any point i need to go back and check the previous month data i need to get the same details from the 2nd table.

    For Ex: I have closing count details till April in the below table, if i select Feb from the drop down i need to get the closing details of Jan Month (from the 2nd table) to the opening details of Feb Month (in the 1st table). But i'm getting the closing count of April only.

    Could you please help

    Thanks

  4. #4
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Copy Paste data based on Month Names

    I thought this was just an archive. You state at the beginning of the year that you enter things manually. You have a note about some random dummy numbers. So we have random dummy numbers in column F, you pick a month the numbers in column F go into that month, those same numbers get copied into column E to be the opening stock and column F is cleared. So now you want to be able to pull a previous months numbers and put them back in the first table? What happens to the numbers that are in the table when we do that?

  5. #5
    Forum Contributor
    Join Date
    12-19-2012
    Location
    Bengaluru
    MS-Off Ver
    Excel 2013
    Posts
    108

    Re: Copy Paste data based on Month Names

    Hi Skywriter,

    We'll enter the opening details only for the starting month of the year (i.E for Jan). For Rest all months the opening stock details should be pulled from the second table only (which would be the closing stock of prior month). We will not enter any other month's opening stock details manually.

    The sock type Stock code and approved stock remains same for every month unless if there is any addition of new stock type. The opening details should be pulled from the 2nd table based on the month chosen from the drop down. and closing details would be calculated based on the formula and other data.

    Previous month's details in the 2nd table won't change. The closing count remains same as once the month ends we'll close the books. The details in the 1st table keeps changing depending on the month selected from the drop down.

    Thank you

+ 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. copy & paste data of current month
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-28-2014, 08:37 PM
  2. copy and paste data month to month
    By hotrod4571 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-23-2013, 01:23 PM
  3. Data copy and paste to multiple sheets by renaming the names
    By Ignesh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2012, 02:37 PM
  4. [SOLVED] Help with a system to auto populate month names based on current month
    By rosboy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-01-2012, 05:17 PM
  5. [SOLVED] Look up Data by month copy and paste
    By mille1sj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2012, 11:31 AM
  6. Copy and paste data from Previous Month
    By dwalton5 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2011, 12:20 AM
  7. copy and paste data with month criteria
    By pani_hcu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-24-2011, 11:23 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1