| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba countif linked to another sheet
hi all,
i want to use a countif formula in vba that will count data from another sheet. this sheet name is variable depending from the date the macro was use. example . run the macro today. -create new sheet name 16-aug -in a sheet "graphic" new row named 16-aug. (for the case in cell D1) -in D2 formula countif("16aug!A2:A25,"=A2") <------- this is what i want - in D3 formula countif("16aug!A2:A25,"=A3") so everytime i run the macro a new sheet is created with a new name and i want to get countif for the the cells under it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy a linked sheet | Excel Discussion (Misc queries) | |||
| How do I add every other coloums in a linked sheet? | Excel Discussion (Misc queries) | |||
| CountIF Function On Linked Spreadsheet | Excel Discussion (Misc queries) | |||
| Transfer/Copy Sheet, Dynamically linked Sheet | Excel Discussion (Misc queries) | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Threaded Mode
