DarrenBurke
New Member
- Joined
- May 6, 2022
- Messages
- 29
- Office Version
- 2016
- 2007
- Platform
- Windows
Hi Guys and Ladies
Yes its me... Japanese thought process going on (lets make it better).
I have a Vlookup formula in worksheet "(Key) Lookup" that looks at worksheet "(Key) Dataset" for the data from the row. Based on the Date.
The main tool in these 2 worksheets is Simple. The Begin Date and the End Date. By changing these dates the data populates correctly from "(Key) Dataset".....This works 110 percent
What would you like to do? I hear ya say.
I would like to not have formulas in the cells. I know i could protect the worksheet, but sometimes the amount collected by the driver is more... or sometimes less and needs to be changed.
(FYI Haven Care Cente, Telesales phone for donations, to help abused women and children,
the telesales ladies get a percentage of what they collect as a salary hence these 2 sheets. I am the Computer guy and i said i will try and create something to help )
here is the data that automatically fills from another macro
"(Key) Dataset"
The formula on this page looks at the above Sheet and returns the data correctly. Iam trying to get the data and then not show formulas, hope i explained it ok. Thank you all for the help
Kindest regards Hive MInds and Thank you
Yes its me... Japanese thought process going on (lets make it better).
I have a Vlookup formula in worksheet "(Key) Lookup" that looks at worksheet "(Key) Dataset" for the data from the row. Based on the Date.
The main tool in these 2 worksheets is Simple. The Begin Date and the End Date. By changing these dates the data populates correctly from "(Key) Dataset".....This works 110 percent
What would you like to do? I hear ya say.
I would like to not have formulas in the cells. I know i could protect the worksheet, but sometimes the amount collected by the driver is more... or sometimes less and needs to be changed.
(FYI Haven Care Cente, Telesales phone for donations, to help abused women and children,
the telesales ladies get a percentage of what they collect as a salary hence these 2 sheets. I am the Computer guy and i said i will try and create something to help )
here is the data that automatically fills from another macro
"(Key) Dataset"
| Lookup | In Range | Date | Ref | Num | Canvased | Collect | Comm | EFT | Customer | Hamper | Hamp/Cost | Penalties |
| 1 | Y | 2022/07/29 | MF | 387 | TALLISMAN HIRE BENONI | RETURN PUMP | ||||||
| 2 | Y | 2022/07/29 | MF | 394 | R100,00 | R100,00 | R100,00 | CASH | M & M HYDRAULICS CC | TAX INVOICE | ||
| 3 | Y | 2022/07/29 | MF | 391 | R600,00 | R600,00 | R600,00 | CASH | NWK LTD | TAX INVOICE | ||
| 4 | Y | 2022/07/29 | MF | 392 | R200,00 | R200,00 | R200,00 | CASH | SPARKLING DRY CLEANERS | TAX INVOICE | ||
| 5 | Y | 2022/07/29 | MF | 393 | R200,00 | R200,00 | R200,00 | CASH | BUSSINES EXPRESS | TAX INVOICE | ||
| 6 | Y | 2022/07/27 | MF | 386 | R300,00 | R300,00 | R300,00 | CASH | CATHY MURRAY | TAX INVOICE | ||
| 7 | Y | 2022/07/27 | MF | 378 | FAME FENCE(PTY)LTD | TAX INVOICE | ||||||
| 8 | Y | 2022/07/27 | MF | 379 | R200,00 | R200,00 | R200,00 | CASH | GRAYTEX METALS | TAX INVOICE | ||
| 9 | Y | 2022/07/27 | MF | 380 | R200,00 | R200,00 | R200,00 | CASH | LUV MOR MUSIC | |||
| 0 | N | 2022/07/25 | MF | 376 | TALLISMAN HIRE BENONI | TAX INVOICE | ||||||
| 0 | N | 2022/07/21 | MF | 374 | R1 000,00 | R1 000,00 | R1 000,00 | EFT | ISA VAN SCHALKWYK | TAX INVOICE | ||
| 0 | N | 2022/07/21 | MF | 375 | R500,00 | R500,00 | R500,00 | EFT | MARK MELTZER | TAX INVOICE | ||
| 0 | N | 2022/07/19 | MF | 339 | R2 200,00 | R2 200,00 | R2 200,00 | EFT | THE VENUE | TAX INVOICE | ||
| 0 | N | 2022/07/19 | MF | 372 | R3 850,00 | R3 850,00 | R3 850,00 | EFT | SANTOVA LOGISTICS | TAX INVOICE | ||
| 0 | N | 2022/07/19 | MF | 369 | R550,00 | R550,00 | R550,00 | EFT | ESTCOURT HYPER CELLAR | TAX INVOICE | ||
| 0 | N | 2022/07/19 | MF | 370 | R550,00 | R550,00 | R550,00 | EFT | AMERICAN FANATICS | TAX INVOICE | ||
| 0 | N | 2022/07/19 | MF | 371 | SANTOVA LOGISTICS | TAX INVOICE | ||||||
| 0 | N | 2022/07/19 | MF | 360 | R400,00 | R400,00 | R400,00 | EFT | LYLE SADDLER | TAX INVOICE | ||
The formula on this page looks at the above Sheet and returns the data correctly. Iam trying to get the data and then not show formulas, hope i explained it ok. Thank you all for the help
| SALARY ADVICE | Saturday, 30 July 2022 | Michael Ferreira | |||||||||
| Begin Date | End Date | ||||||||||
| Jul 27, 2022 | Jul 31, 2022 | MaxRec | 9 | ||||||||
| Lookup | Date | Ref | Num | Canvased | Collect | Comm | EFT | Customer | Hamper | Hamp/Cost | Penalty |
| 1 | 2022/07/29 | MF | 387 | R0,00 | R0,00 | R0,00 | TALLISMAN HIRE BENONI | RETURN PUMP | |||
| 2 | 2022/07/29 | MF | 394 | R100,00 | R100,00 | R100,00 | M & M HYDRAULICS CC | ||||
| 3 | 2022/07/29 | MF | 391 | R600,00 | R600,00 | R600,00 | NWK LTD | ||||
| 4 | 2022/07/29 | MF | 392 | R200,00 | R200,00 | R200,00 | SPARKLING DRY CLEANERS | ||||
| 5 | 2022/07/29 | MF | 393 | R200,00 | R200,00 | R200,00 | BUSSINES EXPRESS | ||||
| 6 | 2022/07/27 | MF | 386 | R300,00 | R300,00 | R300,00 | CATHY MURRAY | ||||
| 7 | 2022/07/27 | MF | 378 | R0,00 | R0,00 | R0,00 | FAME FENCE(PTY)LTD | ||||
| 8 | 2022/07/27 | MF | 379 | R200,00 | R200,00 | R200,00 | GRAYTEX METALS | ||||
| 9 | 2022/07/27 | MF | 380 | R200,00 | R200,00 | R200,00 | LUV MOR MUSIC | ||||
Kindest regards Hive MInds and Thank you
