martinbhoy
08-02-2011, 04:44 AM
Hello all!
I am a new poster on this forum and, despite my best efforts, am still hopless at excel!
I was wondering if I could trouble someone for assistance? I'm trying to devise a VBA which will transfer the relevant data from an excel (2007) stock sheet (in my case; columns A,B,C,J,K and N) to a word template document. I've played around with this excel sheet so that when stock is low on a particular item (row) it will be highlighted, I've used a filter to make this more clear and a "Quantity to order" number will be generated. I'm also planning in future to hyperlink all the materials to the relevant supplier so that the most up to date price can be obtained fairly quickly. That's all went relatively smoothly...I think...
My problem is that I'm trying to create a VBA which will allow me to transfer multiple rows of items low on stock (up to a max. of 8 items) to a word document I use to order materials in on. Is this even possible? I've tried a few things I've read in forms but I'm getting no-where. Code errors by the dozen!
I'm looking for any help at all...I only intended to make a simple format for an older guy in our stores to just punch in the numbers in stock, as he's not very good with computers, but now I've developed a grudge against this and I'm determined to fix it/beat it!
Thanks in Advance!
I am a new poster on this forum and, despite my best efforts, am still hopless at excel!
I was wondering if I could trouble someone for assistance? I'm trying to devise a VBA which will transfer the relevant data from an excel (2007) stock sheet (in my case; columns A,B,C,J,K and N) to a word template document. I've played around with this excel sheet so that when stock is low on a particular item (row) it will be highlighted, I've used a filter to make this more clear and a "Quantity to order" number will be generated. I'm also planning in future to hyperlink all the materials to the relevant supplier so that the most up to date price can be obtained fairly quickly. That's all went relatively smoothly...I think...
My problem is that I'm trying to create a VBA which will allow me to transfer multiple rows of items low on stock (up to a max. of 8 items) to a word document I use to order materials in on. Is this even possible? I've tried a few things I've read in forms but I'm getting no-where. Code errors by the dozen!
I'm looking for any help at all...I only intended to make a simple format for an older guy in our stores to just punch in the numbers in stock, as he's not very good with computers, but now I've developed a grudge against this and I'm determined to fix it/beat it!
Thanks in Advance!