• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help on Macros for the stock inventory sheet

Techtrend

Member
The inputted data from the data sheet has to be automatically copied to respective suppliers sheet with relevant date columns

The details are mentioned in the attached data sheet
 

Attachments

  • Prudence Priority - Purchase-2.xlsx
    198.1 KB · Views: 6
Techtrend
Based Forum Rules:
  • Use Relevant words in the Title and in the tag Box, This will aid future searches.
Questions based Your file:
Your #1
Those sheets can anyone sort as wants. Do You mean Data-sheet?
Your #2
Where is Your sample's Supplier Name?
Your #3
Where is Your sample's Product?
Is date as current date?
Are Your sample sheets done as You've written?
Is there clear login eg with those dates?
What kind of 'marks' should create from Your Data-sheets values?
 
Questions based Your file:
Your #1
Those sheets can anyone sort as wants. Do You mean Data-sheet?
Yes the users can short

Your #2
Where is Your sample's Supplier Name?
Its in 7 B Col

Your #3
Where is Your sample's Product?
Its in 8 B Col

Is date as current date?
Are Your sample sheets done as You've written?
might change as this is only a sample sheet

Is there clear login eg with those dates?
What kind of 'marks' should create from Your Data-sheets values?
from data sheets we need to input the data to respective users sheet
 
#1 If sort ... then Sheet 1 could be any sheet.
#2 .. then there is missing sheet for Supplier
#3 .. then there is missing that from Suppliers sheet
Date? ... okay
Might change ... if someone would make a code, it would work only with that layout. Do You ask to do double work?
Clear logic? ... I see
What kind of ... Could You add based Your Data-sheet values as You've an idea?
... as written above ... there is missing sheet as well as Product.
 
#1 If sort ... then Sheet 1 could be any sheet.
NO sorry ,The 1st sheet will always be data sheet

#2 .. then there is missing sheet for Supplier
The supplier its only a drop down box from where the selection is done

#3 .. then there is missing that from Suppliers sheet
Date? ... okay
Might change ... if someone would make a code, it would work only with that layout. Do You ask to do double work?
Clear logic? ... I see
What kind of ... Could You add based Your Data-sheet values as You've an idea?
... as written above ... there is missing sheet as well as Product.

The Products ,suppliers ,shape will be drop down which is pre fed and the users only select and inputs the data
 
Back
Top