I have a worksheet that I need to copy the values from sheet 2 columns B & C into sheet 1 columns B & C to the next available row. The issue is that the data is not always available in sheet 2, to determine this sheet 2 has an I in column A to show the data is associated with this and I need to insert a 0 in columns B & C if data is unavailable. Any help would be most appreciated.
Bookmarks