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