I need help with a macro which will take info from a range on one sheet and depending on the format and value of the cell in that range insert details into another sheet. I have attached an example as it is a bit awkward to explain and the details below won’t make any sense without the file.
Basically I start with sheet “Basement 6309 Block ECG List”. The info is entered on this sheet and the cells are formatted with a colour depending on the zone.
I have a macro which creates the “Basement Logic Sheet” from another page and sets up all the columns and enters all the required info except for details it takes from “Basement 6309 Block ECG List”.
I have started to fill out “Basement 6309 Block ECG List” manually to show what I need to achieve.
It basically needs to look at the range F8:U70 on “Basement 6309 Block ECG List” looking at each cell individually. If the cell value and format is the same as the cell on “Basement Logic Sheet” column D then “Basement Logic Sheet” row of that cell column H8:U8 is completed from the details of column B and C in “Basement 6309 Block ECG List”
Bookmarks