Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Stock register

  1. #1
    New Member
    Join Date
    Sep 2009
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Stock register

    How I Can Maintain The Stock Register On Excel Sheet By Date Wise ?

    But I do not want to insert any sheet for different dates & also the format will not be copied & paste in the same sheet. Just at the place of Date the date will be changed & the datas will be entered manually for each day.

    In future, when I shall put the date, the datas will show that particular date's datas only.

    Can anyone help me ?

  2. #2
    Board Regular srikanth58's Avatar
    Join Date
    Jun 2006
    Posts
    58
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Stock register

    I think with your conditions you have to use 'user form'. Search the forum how to transfer user form data to a worksheet using VBA and you can pull data for the particular day with VLOOKUP function.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •