Posts by sobi_256

for example 1 shirt is made up of 3 individual components
components qty

25 X 23 X 1220 7

100 X 85X 450 8

50 X 35 X 567 9

so if i order 10 shirts the the outcome will be

components qty

25 X 23 X 1220 70

100 X 85X 450 80

50 X 35 X 567 90

1 shoe is made up of 2 individual components


components qty

LACE BLACK 5

LACE WHITE 6

so if i order 5 shoes the out put sheet should have
components qty

LACE BLACK 25

LACE WHITE 30



i hope i am explaning itself clearly

thank you for reply royUK

I am open to changes , the database now has no empty rows, the output sheet has the information which is related to orders, if in order sheet a product quantity is 30, in utput sheet the items is multipied by 30, output sheet also contains other relevant information

DB.xlsx

Hi all

i am stuck with a problem , i am uploading a file for clarity

DB.xlsx

Here i have 3 sheets, orders, database and output. In order sheet we will input orders(that i can do manually), database sheet has got all the information like quantity, stattion number, which department a particular size to go to.

The output sheet is the answer what i am looking for. I did it manually and i am looking for a vba solution.

thank you so much, much appreciated for your time

Regards
Gamz

thank you, it would greatly help me, btw mine is not stock control, its data from simulation( stresses etc at nodes), i uploaded a makeup excel file so that its easier to understand

thanks royUK .
do u have any examples. I went to ur website which is linked in your signature but could not find

i am afraid i need a vba approach for this

Hi guys

I need a codes that does the following:

if i can find HAMMER in column H then add 3 to the corresponding value , so 2 will become 5

if i cannot find HAMMER in column H then find hammer in column A and then add 1 to corresponding value , so 7 will become 8 if column H do not has Hammer.

regards

q1a.xlsx

columns r hidden because in my actual workbook thr is data in it, ok thx i will use table format, i just wanted to learn how to do this via code and loops.
thanks

Hi

I hope all are doing well. Need some help in some automation

i want to fill the cells with formulas down the rows and across columns. I will attack the workbook as example.

for example

my z column has and ab column, the only change is 2 and 4 in the formulas and i have to automate this

next is column AA AND AC, so here again across columns we change 3 to 5 and down the rows we change from a2 to a3 and b2 to b3 and so on

is thr any way to automate this across columns Z TO AE

Q1EXAMP.xlsx

thx roy, didn't know about this. i always learn something new from this forum

maybe something like this

the above code will only get 100 rows, if u change the link in A1 to the following it will get all the data, but i don't know how to get cell background colours

thx fluff, if u do not like ctrl shift enter then refer to the sheet , if u r okay with ctrl shift enter then use formulas posted by fluff

pls check this out

best thing is to attach a sample workbook

i can only come up with the attached solution,had to insert some columns, thr might be a way to get the desired answer without inserting anything, but i do not know that

if a averageif range is empty then u will get div/0 error, like if rep3 range has no values for nominal -10 it will give an error

can u please attach a sample workbook please

hi if u can replace the dots with / in columns C and D, then use this formula. it works if the actual date is greater than reported date

this one is different, when u add name on worsksheet data, then go to pay sheet and click that button, it will update the combo box