For Option 2 and 3 !
I use mostly office 2013, sharing would create problem also noticed when any company is completely removed summary gives error in Option 2.
Option 1: :cool:
But I prefer formulas instead of vb, as while sharing people are afraid of script codes:rolleyes: and even sometimes...
Hi Guys & Grlz,
I was working on this database and got stuck, i hope some one can help?
The idea is "A company keeping tracking of renting equipments and customers.
The customer can take multiple equipments.
Each equipment has a unique ID. (alphanumeric - XXXX#####) depending on the selection...
Well now there is Google spreadsheet available btw i am not fan of excel but i always most of my solutions in excel. i wish excel could use filter as easy as Google, import other files as easy as Google.:rolleyes:
i am adding the previous quantities by using the below formula in excel its working fine but when i put it spreadsheet its not working
H1 : is my selection month
Row B3:M3 is my date
Row B4:M4 is my data which is i am adding using above formula.:awesome:
Did anyone tried to link excel data with visio 2013 to create graphs ?
I was trying to link excel data with visio by: (try any data) so if i change value i excel it should also reflects in visio graphs.
In Vision 2013,
Under Data Menu
>Link Data to Shapes
That was quick reply, but if you notice the date i want is in financial year and that's fixed if "end date falls with that date chart would look fine but if date goes above my FY13. it should plot whole line. (look project 4)
I was thinking about putting an extra column and hiding it but still...