Hi,
That can be done in various ways, i.e. by formulas, by a macro that you can be run on demand, or by using embedded code that detects a change in a certain column or cell then automatically fires a macro that will copy your data to the other sheets. Any preferences?
Also I would need the file in order to give you a specific answer or custom solution. Is it ok to send the file?
I don't have any preferences as long as it works. I would be more than happy to send the file, Just tell me where.
Kimber
Ok, here is how to upload the file:
1. go to http://fileqube.com 2. click ‘Browse' then select your file3. click ‘agree and upload' button (when it finishes uploading a new page will be displayed)4. click on the link next to 'Download link' and copy that link, then come back to this page and paste the download link in your reply.
(Note: If you want the file to be later removed from the server please make sure to save the 'Delete link' that you will get after uploading the file).
http://www.fileqube.com/file/ivcfJgomk206681
file has been uploaded
Kimber,
I got the file. Thanks.
Will start working on it later today and should complete the work by this evening PST. If you need it earlier please let me know.
In the meantime if I need any clarification I will be posting a message or two.
Ok, here we go.
FILE
The operation is performed by a macro which is triggered by clicking the button "Copy Items to Purchase Order" located at the top of the sheet "To Be Ordered".
When the button is clicked, the macro will first clear any previous items from the Purchase Order, then it goes through the items in the sheet "To Be Ordered" starting from row 4 down to the last row of data in that sheet. It looks for the items whose Quantity are not zero. It then copies the appropriate cells of each of these items into its proper field in the Purchase Order. (If you want the macro to copy ALL the items listed in that sheet and not just the ones which have quantities let me know and we change that).
Go ahead and test it by typing different quantities in the Quantity fields of the "To Be Ordered" and run the macro to see if it works the way you want it.
Hope this is ok. Let me know if you want to have any modification or if you have any question. If all is ok,thank you for clicking Accept.
Glad to hear that.
Would that be cell H4 in the Purchase Order sheet, because the code that is in the original program places the sequence PO # in cell G4. Could you please verify and let me know.
That's ok, here is the modified file in case you still need it
You can specify me by writing "For John D" in the subject of your next question.
By the way you have not yet clicked the green Accept and that is the only way I get paid for my work. Thanks.
BS Degree in Engineering
20 years experience in Excel programming and various major applications.