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
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
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
