Can someone please help me?!?! I started this spreadsheet to help me manage my accounts receivable. For the life of me, I can't figure it out. I think I'm making this more complicated than it really needs to be, but I just can't figure it out. Basically, I copy and paste AR information from our Corporate Website (that's the only way it's available) into the "Working Sheet - OM Use Only" sheet (this is the only sheet that can be changed as far as formatting and information goes). Then, once I paste the information there and make my notes, I want any of the items that are between 0-15 days old, to be copied to a cell on the corresponding tab, anything from 16-30 copied to that tab and so forth and so on. On the OM Sheet, the Recheck Date, Tab and Days Old Columns should NOT be copied to the corresponding sheets. I put them in there when I was trying to figure this out myself.
Can someone PLEASE help me?!?! My spreadsheet is attached for convenience.
Thanks a million!!
Bookmarks