Expertise required!

[Joel Rodrigues]

Hi Guys,

I need your assistance in completing my sheet. This sheet consists of names of Control & Pressure Safety Valves. When I insert the valve name/number, it should look up all the other details and add it to my main sheet. Every day I have to enter x no of valves and generate a report at the end of the day.

I have inserted most of the formulas, but when I filter the dates, the row count does not show up. It shows the total number of valves under each date, but the formula does not show the value in Column N when filtered. However, if the filter is off, it works fine.

Secondly, I want to show the count of rows in my Left footer. I tried the Macro, but it does not work! It shows only the first sheet row count on all page footers.

I also wanted to know if I could freeze my slicers to the left as I go down entering my data. I tried the freeze option, but it freezes the top 20 rows and I don’t want it that way. I only want the slicers to freeze and not the row or columns.

I have another problem! I have inserted formulas in Column E, F, G, H, N, O, & P. I want to lock these cells. When I lock these cells, I am not able to use the TAB key at the end of each row (just before the total) to insert a new row. Kindly advise as to how can I lock these columns and yet be able to insert new rows using the TAB key.

Would really appreciate your earliest feedback.

File attached for your perusal

Thank you for your time and cooperation

 

[Joel Rodrigues]

Hi,

I am extremely sorry for not being clear with my problem in the Title.

1. I have a problem with my Macro as it is not showing me the count of rows of each page.
It just shows me the row count of first page across footer of all pages.

2. My Slicers in the file cannot be frozen and keep moving as I go down updating my rows.
I need them to stay fixed so that I need not scroll up and down to filter my requirement.

3. When I filter any of the criteria, the row count does not show in the footer for the
selected data.