SaltedSeaSlug
New Member
- Joined
- May 9, 2019
- Messages
- 1
Hello all,
I am very new to VBA and macros and have a question regarding how to obtain an average of certain cells while skipping those which do not contain values. I will explain what I am dealing with more closely.
The worksheet in question was already made and I am tasked with updating it. Currently, there are 3 tables that are 13 columns wide and have 54 rows that allow users to enter data. However, every other cell is blocked out with "---" to restrict users from entering data from that cell. On top of that, the tables are conditionally formatted based on a selection made by the user. The table layout changes based on this selection. For instance, one choice will create a table that is 7 cells x 12 cells. Another may be 6 x 8. Vlookup is used in conjunction with another macro to hide rows and columns that are not applicable.
The goal is to find the average of the same cell location of each of the 3 tables and place this calculation in a 4th table. I would just use the average function in Excel, however the cell is already populated with the vlookup formula to format the table. I am open to any suggestions and any help would be greatly appreciated
I am very new to VBA and macros and have a question regarding how to obtain an average of certain cells while skipping those which do not contain values. I will explain what I am dealing with more closely.
The worksheet in question was already made and I am tasked with updating it. Currently, there are 3 tables that are 13 columns wide and have 54 rows that allow users to enter data. However, every other cell is blocked out with "---" to restrict users from entering data from that cell. On top of that, the tables are conditionally formatted based on a selection made by the user. The table layout changes based on this selection. For instance, one choice will create a table that is 7 cells x 12 cells. Another may be 6 x 8. Vlookup is used in conjunction with another macro to hide rows and columns that are not applicable.
The goal is to find the average of the same cell location of each of the 3 tables and place this calculation in a 4th table. I would just use the average function in Excel, however the cell is already populated with the vlookup formula to format the table. I am open to any suggestions and any help would be greatly appreciated