Harry0
Member
I uploaded a schedule formula which I showed a while ago but is there a better way so that a person that does not know excel at all has another type which they can use it?
Here are some issues that a non excel person can not use.
The issue is as the tab says its a january tab and every month you have to add another, which column BL has to reference the last month tab CB.
The other thing is not every month has 4 months which takes a while to add another row.
And probably some smaller issues like if they add a new client they might not know hoe to add them with the number code and can cause problems on previous weeks.
And I can do 5 schedule of the week within the month but when I go more like 12 or more it lags.
I know there are some ways but it's a bit too much for me. This method uses a reference (column bp, bt, etc) to remember when the next time is which it is reaches 1 it gets triggered and pops up the code that should be used. I got confused in thinking to use a algorithm and other methods are overwhelming and confusing.
I am using excel 2011. it seems to not work with other versions or Mac numbers.
Here are some issues that a non excel person can not use.
The issue is as the tab says its a january tab and every month you have to add another, which column BL has to reference the last month tab CB.
The other thing is not every month has 4 months which takes a while to add another row.
And probably some smaller issues like if they add a new client they might not know hoe to add them with the number code and can cause problems on previous weeks.
And I can do 5 schedule of the week within the month but when I go more like 12 or more it lags.
I know there are some ways but it's a bit too much for me. This method uses a reference (column bp, bt, etc) to remember when the next time is which it is reaches 1 it gets triggered and pops up the code that should be used. I got confused in thinking to use a algorithm and other methods are overwhelming and confusing.
I am using excel 2011. it seems to not work with other versions or Mac numbers.