Ira Hopkins
New Member
- Joined
- Apr 8, 2019
- Messages
- 25
Hi
I have a spreadsheet with 2 tabs. 1 is called histories and the other is order- ( it wont let me do add in to attach file as work fire walls to do as attachment)
I need the type on histories to fill in ok if more than one entry on orders but if only one entry to say exactly what is on type column in order tab. Also if the code appears more than once on order tab I need to add together for histories tab on the total column and again if not put what it is from order tab. Thanks so much
Top is the order tab and bottom is history tab-
I have a spreadsheet with 2 tabs. 1 is called histories and the other is order- ( it wont let me do add in to attach file as work fire walls to do as attachment)
I need the type on histories to fill in ok if more than one entry on orders but if only one entry to say exactly what is on type column in order tab. Also if the code appears more than once on order tab I need to add together for histories tab on the total column and again if not put what it is from order tab. Thanks so much
Top is the order tab and bottom is history tab-
Code | date | Type | Total |
F2091 | 01/05/2024 | Normal | £10 |
F2092 | 02/05/2024 | Normal | £10 |
F2093 | 03/05/2024 | Normal | £10 |
F2094 | 04/05/2024 | Normal | £10 |
F2095 | 05/05/2024 | Normal | £10 |
F2096 | 06/05/2024 | Normal | £10 |
F2097 | 07/05/2024 | Normal | £10 |
F2098 | 08/05/2024 | Normal | £10 |
F2099 | 09/05/2024 | Normal | £10 |
F2100 | 10/05/2024 | Normal | £10 |
F2091 | 01/05/2024 | Urgent | £12 |
F2092 | 02/05/2024 | Urgent | £12 |
F2093 | 03/05/2024 | Urgent | £12 |
Code | date | Type | Total |
F2091 | |||
F2092 | |||
F2093 | |||
F2094 | |||
F2095 | |||
F2096 | |||
F2097 | |||
F2098 | |||
F2099 | |||
F2100 | |||
F2091 | |||
F2092 | |||
F2093 |