Filter on date and paste to value destination
Closed
Jan
-
Apr 23, 2010 at 11:51 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 28, 2010 at 12:33 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 28, 2010 at 12:33 PM
Related:
- Filter on date and paste to value destination
- Safe search filter - Guide
- Filter unknown senders android - Guide
- Snapchat black and white filter - Guide
- How to paste photo in resume - Guide
- Apply snapchat filter to existing video - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 23, 2010 at 01:03 PM
Apr 23, 2010 at 01:03 PM
Could you please upload a sample file on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.
I tried upload a picture but it was too large.
The categories spreadsheet is basically a list of categories with the data underneath containing check date, check number, vendor name, invoice date and amount.
Like so:
#201 Sheetrock
4/15/10 1234 ABC Vending 10410 $3,000
4/16/10 1235 SomeCo 243999 $100
#202 Permits
3/9/10 1239 Permits Inc 48846 $2500
#203 Light Fixtures
4/25/10 1243 LightsRUs 595752 $600
The data sheet that it comes from is in this format:
Check date checknumer Vendor invoice number Amount Categorie#
4/15/10 1234 ABC Vending 10410 $3,000 201
4/16/10 1235 SomeCo 243999 $100 201
3/9/10 1239 Permits Inc 48846 $2500 202
4/25/10 1243 LightsRUs 595752 $600 203
I want to be able to select a check date by a user form and then have it put the data into the category it belongs under in another spreadsheet.
The categories spreadsheet is basically a list of categories with the data underneath containing check date, check number, vendor name, invoice date and amount.
Like so:
#201 Sheetrock
4/15/10 1234 ABC Vending 10410 $3,000
4/16/10 1235 SomeCo 243999 $100
#202 Permits
3/9/10 1239 Permits Inc 48846 $2500
#203 Light Fixtures
4/25/10 1243 LightsRUs 595752 $600
The data sheet that it comes from is in this format:
Check date checknumer Vendor invoice number Amount Categorie#
4/15/10 1234 ABC Vending 10410 $3,000 201
4/16/10 1235 SomeCo 243999 $100 201
3/9/10 1239 Permits Inc 48846 $2500 202
4/25/10 1243 LightsRUs 595752 $600 203
I want to be able to select a check date by a user form and then have it put the data into the category it belongs under in another spreadsheet.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 28, 2010 at 12:33 PM
Apr 28, 2010 at 12:33 PM
How big of a file is this ? Try to zip and then upload and then post the link.