Populating Sheet Based off date criteria in another

Closed

Wes - Oct 11, 2015 at 01:30 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 11, 2015 at 05:46 PM

Hello,

I have a database that I would like to auto populate all of the 2015 events into a 2015 sheet. I need the data in both sheets as the main is an archive of all events. Both sheets will have the same layout. They both are set up as tables.

Sheet 1 is the main database. Sheet 4 is where I want the 2015 events to land.

The table header that I would need to sort by is named "Date" and is located @ "C2"

The Data base information I want transferred over would go from Column "B" to Column "AU"

Populating Sheet Based off date criteria in another
Little alchemy cheat sheet - Guide
Excel macro to create new sheet based on value in cells - Guide
Based on the values in cells b77 b81 ✓ - Excel Forum
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
How to copy data from one sheet to another in excel automatically - Guide

2 responses

Answer 1 / 2

xpcman Posts 19531 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,833
Oct 11, 2015 at 01:36 PM

I suggest you hire a contract programmer.

Answer 2 / 2

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 11, 2015 at 05:46 PM

what have you done/attempted so far to get your "wants/needs" completed

Similar discussions

Excel - IF function with multiple words

copy a row from one worksheet to another, based on criteria

How do I change a base location on Instagram?

Code to move rows into another sheet based on certain values

Code for macro that conditionally inserts rows

Similar discussions

Subscribe To Our Newsletter!