I have a master sheet with potential expenses listed. Once I decide that I will for sure submit these expenses, I put a number (a new number for each row) in the first column. What I would like is to return the entire row on a new worksheet (for the report that I will actually submit). I have been able to do this on a cell by cell basis, but have not been able to return the whole row. Tried using VLOOKUP but not sure that I am doing it right.
Second, on the new worksheet, i would like to return only rows that have a number in the first column. However, when I try to make this happen, I have only been able to refer to the exact row position. This means I can tell NewWorksheetB1 to return MasterB1 if greater than zero, but if less than zero I just get a blank row. Instead, I am hoping on the New Worksheet I can have all the rows with numbers returned but without any blank rows in between.
sorry, I should have mentioned this to start, but the worksheet will be used on a Mac which does not allow macros in the newest version.
Second, on the new worksheet, i would like to return only rows that have a number in the first column. However, when I try to make this happen, I have only been able to refer to the exact row position. This means I can tell NewWorksheetB1 to return MasterB1 if greater than zero, but if less than zero I just get a blank row. Instead, I am hoping on the New Worksheet I can have all the rows with numbers returned but without any blank rows in between.
sorry, I should have mentioned this to start, but the worksheet will be used on a Mac which does not allow macros in the newest version.