N
Newdlj
I am having 1 major problem currently, and will have another problem
potentially in the near future.
In the last tab "Weekly Time Sheet", I have created a pivot table,
which works to perfection. I have also created in Column A a
description for each of the codes given in the pivot table. This
description is pulled from a range that has been created in N18:O76.
However, the problem is, I can't seem to figure out how to have a blank
cell show up if there is not a code given in column B. There is no
guarantee that I will work on the same projects on a weekly basis. Is
there a way to include a lookup statement and an IF or OR statement
together? Or perhaps there is an easier way to do it all together.
Secondly, the biggest problem. Although the LOOKUP range will work
currently, because I have manually established which codes and
descriptions go into it. However, the project codes are constantly
being updated. How can I make sure that my range is constantly being
updated as well? Any suggestions on that?
potentially in the near future.
In the last tab "Weekly Time Sheet", I have created a pivot table,
which works to perfection. I have also created in Column A a
description for each of the codes given in the pivot table. This
description is pulled from a range that has been created in N18:O76.
However, the problem is, I can't seem to figure out how to have a blank
cell show up if there is not a code given in column B. There is no
guarantee that I will work on the same projects on a weekly basis. Is
there a way to include a lookup statement and an IF or OR statement
together? Or perhaps there is an easier way to do it all together.
Secondly, the biggest problem. Although the LOOKUP range will work
currently, because I have manually established which codes and
descriptions go into it. However, the project codes are constantly
being updated. How can I make sure that my range is constantly being
updated as well? Any suggestions on that?