+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 26 of 26

Looking for help with daily auto population of fields

  1. #16
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,373

    Re: Looking for help with daily auto population of fields

    Try this version. This is a starting point. You need to give me samples of before and after data.
    Attached Files Attached Files
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  2. #17
    Registered User
    Join Date
    01-28-2014
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2016
    Posts
    43

    Re: Looking for help with daily auto population of fields

    I could post the actual file if that would help, I am sure you would be able to see how limited my excel skills are by seeing how I have handled the data so far.

  3. #18
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,373

    Re: Looking for help with daily auto population of fields

    No Need.

    Lets get the sample working.

    Ahh I see the issue. Sorry I posted the wrong version.

    In this version I have posted 5 new products

    Running the data saves the new data in the Inventory list. How do you need that data saved

    new1 Quantity in Stock =10, Quantity on Order =2

    So Column F = 10, Column G = 8 ?????????????????
    Attached Files Attached Files
    Last edited by mehmetcik; 01-05-2019 at 08:53 PM. Reason: Subtracted Orders From Stock. New Products

  4. #19
    Registered User
    Join Date
    01-28-2014
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2016
    Posts
    43

    Re: Looking for help with daily auto population of fields

    Do you know why I am seeing numbers where currency should be and currency where numbers should be? The columns seem to change format part way down. Also on the Daily Sales sheet the sales column is equal to what I am see on the Inventory List sheet?
    To answer the questions you have asked Quantity on Order is in column O and can be filled when the new data gets pasted to the Daily sheet.
    Column F =10 (previous number from previous days entry made on Load Daily sheet column E) , Column G = Load Daily sheet column E

  5. #20
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,373

    Re: Looking for help with daily auto population of fields

    Ok.

    I have rewritten the bulk of this.
    I originally used The Copy Destination function. That Messed up the formats.


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

  6. #21
    Registered User
    Join Date
    01-28-2014
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2016
    Posts
    43

    Re: Looking for help with daily auto population of fields

    Thank you again. I am still seeing some issues like column E Load Daily first 5 entries are showing as currency which I think is throwing data off the first 4 calculation for column G on Inventory List sheet? On Daily Sales sheet I am seeing 0 in column D after loading the items a second time? Is it possible we aren't running the same version of excel.
    Please don't think I am complaining, what I am seeing is a file that is almost doing what I asked for. A little more explanation from my side may have made it easier to get to this point.
    This file is amazing and maybe it is time for me to try to learn VBA to try to make the changes I want.

  7. #22
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,373

    Re: Looking for help with daily auto population of fields

    Q: I am still seeing some issues like column E Load Daily first 5 entries are showing as currency which I think is throwing data off the first 4 calculation for column G on Inventory List sheet?

    I see a problem there. F - O =G but only the first time the Macro Runs.
    O increases each time the macro runs, F decreases. So after the first time F - O <>G

    F does not actually provide useful information. I will check to see if I used that column in the calculations.

    Q: On Daily Sales sheet I am seeing 0 in column D after loading the items a second time? Is it possible we aren't running the same version of excel.
    The zeros are in your data, they are never over written. Did you want them removed?


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 01-06-2019 at 12:40 PM.

  8. #23
    Registered User
    Join Date
    01-28-2014
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2016
    Posts
    43

    Re: Looking for help with daily auto population of fields

    Tried this several times and I keep seeing Daily Sales column D populate with Load Daily Here column F. I was hoping to see column D on Daily Sales sheet to equal column F minus column G on the Inventory List sheet, this would have to happen after column G shifts to F and the new daily Quantity in Stock from column E from the Load Daily sheet loads to column G on the Inventory List sheet.

  9. #24
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,373

    Re: Looking for help with daily auto population of fields

    That is the Daily Sales Sheet right?

    So you need that to reflect sales on that day.

    Column F - Column G gives you sales on that day. Column F + Column O only equals Column G on the first pass.

    On Tuesday You Have 10 of Item A Columns F and G

    On Wednesday you sell 2 of Item A so Column F =10, Column G = 8, Column O =8 G - F = 2 =O Correct 2

    On Thursday you sell 3 of Item A so Column F =8, Column G = 5, Column O =5 G - F = 3 <>O Correct 5

    On Friday you sell 2 of Item A so Column F =5, Column G = 3, Column O =7 G - F = 2 <>O InCorrect 7

    I did find one issue

    Corrected by:-

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 01-06-2019 at 02:17 PM.

  10. #25
    Registered User
    Join Date
    01-28-2014
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2016
    Posts
    43

    Re: Looking for help with daily auto population of fields

    Column O is a totally different measure that might be used later to measure what the minimum should be or to see how often I am buying the item. So on the Load Daily sheet column F could populate 2 in column O of Inventory List sheet and could continue until the item is received which would be added at the data source and would populate E on the Load Daily sheet when pasted in.
    On the Load Daily sheet 10 could be the number loaded into E on one day but because there are 4 orders for this item with the source 3 could come in on one day, 4 a couple of days later and before all 10 are in 6 more could be ordered pushing the number that would load in E to 9 again.
    Very confusing for me and I typed this, let me know if you need it explained a different way.
    Thank you

  11. #26
    Registered User
    Join Date
    01-28-2014
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2016
    Posts
    43

    Re: Looking for help with daily auto population of fields

    Thank you for all of the help with my request. I have been studying VBA and I appreciate the opportunity to fine tune this code to be added to my original file.
    I really appreciate all of the time and patience you put into my request and hope to work with you again.

    Thank you

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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