Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy last 13 items
I have 2 worksheets no1 is a continuous row after row of monthly listings
i.e. date, amount, no of items from 1999 to date. Worksheet no2 just shows the last 13 months. I would like a formula to go in worksheet 2 so it will automatically update its self after the current months figures have been added to the bottom of worksheet no1. I was told =offset(a1,count(a;a)-1,0) would give me the last item in a row less 1, but have not been able to get it to work successfully, Any other suggestions gratefully received. Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you copy items from many worksheets to one? | Excel Discussion (Misc queries) | |||
copy items | Excel Discussion (Misc queries) | |||
Run a macro to copy selective items | Excel Discussion (Misc queries) | |||
Is it possible to copy only selected items to another worksheet... | Excel Worksheet Functions | |||
How do I copy specific items to another worksheet? | Excel Worksheet Functions |