hello
I need help about merge duplicated data and summing & subtracting among multiple sheets , what I want when I fill data in any sheet then combined the data and summing , subtracting among columns contain value and show in sheet "inventory" I have about 5000 row data but I attached a simple file to understand my idea I put the result in sheet " inventory about the data and value I put one to understand how the formula how can be
thanks in advance
Use the sumif() function
Formula:
Please Login or Register to view this content.
thanks daves for the formula I think it needs code because I have ever said when I fill any sheet supposes merge data and sum & subtracting in sheet inventory moreover I think you misunderstood me the result in sheet inventory should be automatically not write manually every repeated brand , it takes more time
Last edited by abdo meghari; 12-29-2020 at 05:45 AM.
any help guys ?
Are you just wanting to have seperate sheets for Sales & Purchases etc.
If so you have the answer in a previous submission of mine.
All you have to do is add your new sheets and direct the code/calculations to the individual sheets.
torachan
thanks torachan but this case is different I have duplicated data in multiple sheets so before sum or subtract the value supposing merge duplicated data in sheet "inventory"
Try
Please Login or Register to view this content.
When you have got rid of your duplicates and have a set of unique data here is a simple inventory app with individual forms so that there is no confusion.
torachan.
Last edited by torachan; 01-01-2021 at 04:04 AM.
well done ! jindon this is what I want and if is possible explain some values especially 0 ,1
in theses lines
thanks againHTML Code:
Last edited by abdo meghari; 12-31-2020 at 02:20 PM.
@torachan your file is very interesting but you seem don't understand the whole story I repeat the same brand in sheet "purchase" it supposes showing value 12 in sheet "inventory" but it show 1 as the attached file
Elements in an array are all array(jugged array) and 1st element is the sheet name to loop and 2nd element is the switch for addition/subtraction.
1 for addition, 0 for subtraction.
used in the line of
Please Login or Register to view this content.
many thanks @ jindon for your code and explanation
best regards,
abdo
hi, jindon
first of all I issue a new thread but the moderator closes and consider this duplicated
I would amend the code based on what I put in sheet"inventory1"
it supposes summing duplicated data in other sheets and put the result in columns f, g, h, I based on name headers are the same sheets name to understand it
thanks again
Change to
Please Login or Register to view this content.
brilliant ! brilliant! thank word is Very little for your right
million thanks
take care buddy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks