$$Excel-Macros$$ Need help with a couple subs

2013-01-24 Thread 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. I've attached a sample .xslm file which I'll be referencing throughout this post. So what I'm trying to do is use the workbook as a tool to simplify orderin

Re: $$Excel-Macros$$ Need help with a couple subs

2013-01-26 Thread ashish koul
Hi Richard just a suggestion - Why don't u consolidate/ merge all the input sheets to single then create a simple pivot table for ur analysis below macro will merge data from multiple sheets to single you might have to do minor changes so that it meets your requirement Sub merge1() Dim i As Lon

Re: $$Excel-Macros$$ Need help with a couple subs

2013-01-28 Thread Richard Bridges
Thanks for the help, Ashish. I'll play around with it and see if I can get it to work for me. Richard > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent