Transposing Data From One Sheet To Another Within Same Workbook (IF?)

**Gtrtim112** · 05-01-2013, 09:09 AM

I'm trying to get information from one worksheet to copy over to another worksheet based on certain criteria... namely, a date. I'm going to attach a copy of an example with the explanation it. I think this will call for an IF or IFS formula but I'm not completely sure. If there is anyway to keep the formula to any version of Excel, that would be great but if it needs to be a newer version to use IFS or something similar, I could deal with it. I'll just be happy if someone can actually figure it out... lol.

Lem... feel like being challenged again?

**djapigo** · 05-01-2013, 05:03 PM

This has been done before... see if this thread (solved by Pete) might work for you...

http://www.excelforum.com/excel-prog...dar-dates.html

**Lemice** · 05-01-2013, 07:23 PM

Hello,

Here is a sample for January only (the other month should be the same). Let me know if this is the type of file you are looking for.

Edit: I have changed the file, and attempt a copy paste from worksheet Jan to worksheet Feb, and it is working.
Currently there is no helper column, but you will have to notice that I deleted unnecessary merged column.

**Gtrtim112** · 05-01-2013, 10:57 PM

I need the formula for a box that will spit out $100 bills, please. Make the copy straight over to my bank account... lol

It's really amazes me that y'all can figure all these formulas out. It's almost as if you can't be stumped. Everything I've asked about has been solved. Great job!