Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically move row to another worksheet | Excel Discussion (Misc queries) | |||
Adding worksheet tab names to the first worksheet | Excel Discussion (Misc queries) | |||
Copy data automatically onto a separate worksheet | Excel Discussion (Misc queries) | |||
Can I import many .txt files in a single worksheet automatically? | Excel Worksheet Functions | |||
Pasting data without the worksheet automatically delimiting it? | Excel Discussion (Misc queries) |