Outstanding! Thank you so much. On Mar 25, 1:02 pm, ashish koul <koul.ash...@gmail.com> wrote: > check this > > have create a macro to add quarters also one to hide the value of > individual quarters so you don need to delete anything > > > > On Fri, Mar 25, 2011 at 7:58 PM, 0 1 <hhholme...@gmail.com> wrote: > > I can no longer find where to attach/upload documents. > > > I've linked a sample spreadsheet here though: > >http://dl.dropbox.com/u/6817228/macrotosum.xlsx > > > I also tried to do some of it manually (e.g., AA = B+C, AB = D+E, > > etc.), hoping I could create the formula once (AA = B+C) and then > > "drag" it across and have it become D+E, F+G, etc. (thus summing every > > column pair). But instead it becomes C+D, D+E, etc. (i.e., D is > > repeated). I tried to play around with absolute vs. relative > > references but nothing worked. > > > Ultimately, a macro would be great, but absent that I'd welcome any > > suggestions on how to simply manually drag a base formula and have it > > transform accordingly. > > > Thank you. > > > On Mar 24, 8:37 pm, ashish koul <koul.ash...@gmail.com> wrote: > > > can you attach the sample data and headers you are using > > > > On Fri, Mar 25, 2011 at 1:53 AM, 0 1 <hhholme...@gmail.com> wrote: > > > > I have a spreadsheet with States as rows. For each State, there are 4 > > > > columns of data for Year 1, then 4 more columns of data for Year 2, > > > > and so on. Each column represents a quarter for that year. > > > > > For example: > > > > > Column A lists the State > > > > --- > > > > Column B data for 1st quarter, 2000 > > > > Column C data for 2nd quarter, 2000 > > > > Column D data for 3rd quarter, 2000 > > > > Column E data for 4th quarter, 2000 > > > > --- > > > > Column F data for 1st quarter, 2001 > > > > Column G data for 2nd quarter, 2001 > > > > Column H data for 3rd quarter, 2001 > > > > Column I data for 4th quarter, 2001 > > > > --- > > > > etc. > > > > > I would like to write a macro that, for each year: > > > > > - sums the 1st and 2nd quarter and replaces the two columns with one > > > > column holding the sum > > > > - sums the data for the 3rd and 4th quarter, and replaces the two > > > > columns with one column holding the sum > > > > > Resulting in: > > > > > Column A lists the State > > > > --- > > > > Column B data for 1st+2nd quarter, 2000 > > > > Column C data for 3rd+4th quarter, 2000 > > > > --- > > > > Column D data for 1st+2nd quarter, 2000 > > > > Column E data for 3rd+4th quarter, 2000 > > > > --- > > > > etc. > > > > > Any suggestions about how to go about tackling this? > > > > > Thank you. > > > > > 2003 2004 > > > > State CountA CountB CountC CountD CountA CountB CountC CountD > > > > > And so on for many year > > > > > -- > > > ---------------------------------------------------------------------------------- > > > > Some important links for excel users: > > > > 1. Follow us on TWITTER for tips tricks and links : > > > >http://twitter.com/exceldailytip > > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > > Like our page on facebook , Just follow below link > > > >http://www.facebook.com/discussexcel > > > > -- > > > *Regards* > > > * * > > > *Ashish Koul* > > > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > > > *akoul*.wordpress.com <http://akoul.wordpress.com/> > > > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > > > P Before printing, think about the environment. > > > -- > > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > >http://www.facebook.com/discussexcel > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > P Before printing, think about the environment. > > Copy of macrotosum.xlsm > 28KViewDownload
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
