About Us

dpgreen

Quote:

Originally Posted by Spencer101

Hi,

Do you mean you need it to sum all values that fall into each quarter?

Which version of Excel are you using?

Any chance of a sample workbook with dummy data?

S.

Hi Spencer,

Thanks for getting back to me, I've attached an example of what I'm working with. I'm sure there is a fairly simple solution but excel can't seem to recognize the pattern so I'm having to do it manually for over 300 workbooks. Plus these workbooks are update automatically each month so I would like for the formula to be able to account for that.

Thanks,

Dan

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy cell values only	tkraju via OfficeKB.com	Excel Programming	8	April 14th 09 10:00 PM
Copy values from a cell based on values of another cell	Spence10169	Excel Discussion (Misc queries)	4	January 13th 09 10:01 AM
Copy values to a different cell	Kanga 85	Excel Worksheet Functions	2	December 10th 08 06:01 PM
VAB to copy cell values into new Sheet, Overwrite if needed and based off of Cell Value in a column	gumby	Excel Programming	4	July 14th 07 01:55 AM
How do I copy cell values in VBA	Jurado	Excel Programming	0	June 30th 05 11:57 PM

Menu

About Us