R
Richard Bridges
Hi guys,
I'm having trouble writing a couple subs. I'm new to vba, so what I'm asking for may be very complicated. If so, I apologize. So what I'm trying todo is use the workbook as a tool to simplify ordering. People will send in their order sheets, which will be pasted into the master workbook. Therewill be different numbers of order sheets received any given day, so the code would need to take into account a variable number of worksheets. Components are categorized based on the recipe in which they are used, so component 1 in recipe 1 may differ from component 1 in recipe 2. What I would like is to identify components in each sheet that need to be ordered (I was thinking an If...Then loop for values <> 0 in column F) and transfer all values in their rows over to an AllOrders sheet. I would like to then compileall the orders by component onto a TotalComponentry sheet (perhaps by matching strings or equating strings in column A? does vba even have an object for this?), and sum the values of their respective 'order this much' cell. I realize this is probably confusing, so I have prepared a sample xlsm sheet I could send that would probably help a lot in explaining my request. I'm not even sure where to start, so any help would be appreciated. Thanks in advance.
Richard
I'm having trouble writing a couple subs. I'm new to vba, so what I'm asking for may be very complicated. If so, I apologize. So what I'm trying todo is use the workbook as a tool to simplify ordering. People will send in their order sheets, which will be pasted into the master workbook. Therewill be different numbers of order sheets received any given day, so the code would need to take into account a variable number of worksheets. Components are categorized based on the recipe in which they are used, so component 1 in recipe 1 may differ from component 1 in recipe 2. What I would like is to identify components in each sheet that need to be ordered (I was thinking an If...Then loop for values <> 0 in column F) and transfer all values in their rows over to an AllOrders sheet. I would like to then compileall the orders by component onto a TotalComponentry sheet (perhaps by matching strings or equating strings in column A? does vba even have an object for this?), and sum the values of their respective 'order this much' cell. I realize this is probably confusing, so I have prepared a sample xlsm sheet I could send that would probably help a lot in explaining my request. I'm not even sure where to start, so any help would be appreciated. Thanks in advance.
Richard