Adding an AP to a worksheet automatically
Hi all,
I've been trying to achieve the above now for a couple of weeks and I've got nowhere. Please could someone help me? I have a list of transactions in a worksheet which I need to automatically count, both by AP and where they were made. I have a start date in cell O4 and a finish date in P4, which contains the dates for AP1, dates for AP2 are in O5 & P5 respectively. The dates of the transactions is in column C, starting at cell C3. I need to put a '1' into cell A3 if the date in C3 is between the dates in O4 and P4 inclusive, or a '2' if the transaction dates are in O5 and P5. Does this make sense? If so, I would be extremely grateful for any pointers TIA -- Regards Dave |
Adding an AP to a worksheet automatically
Hi Dave,
What is an AP? -- Kind regards, Niek Otten Microsoft MVP - Excel "Dave" wrote in message ... | Hi all, | I've been trying to achieve the above now for a couple of weeks and I've got | nowhere. Please could someone help me? | | I have a list of transactions in a worksheet which I need to automatically | count, both by AP and where they were made. I have a start date in cell O4 | and a finish date in P4, which contains the dates for AP1, dates for AP2 are | in O5 & P5 respectively. The dates of the transactions is in column C, | starting at cell C3. | I need to put a '1' into cell A3 if the date in C3 is between the dates in | O4 and P4 inclusive, or a '2' if the transaction dates are in O5 and P5. | Does this make sense? If so, I would be extremely grateful for any pointers | | TIA | | -- | | Regards | | Dave | | |
All times are GMT +1. The time now is 12:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com