We have an excel spreadsheet with multiple tabs and VB programming. It was doing everything we ever wanted, until we have added a new tab "Current year". We are trying to take information from the "Master" tab and copy it to the "Current year" tab if column G has a date that is the current year "2013". (cell G is yyyy format).
Both spreadsheets(“Data file” and “Current year”) have column headings and the data input starts at A5 and goes to L250.
We added the formula =IF('Input here'!$G2=2013,'Input here'!A2,"") to cell A2 on the "2013" tab and copied it across and down. It seems to copy the data we require, but is giving blank lines when the criteria is not. We do not want the end user to have to filter the blank lines out. Does anyone know a code/or formula that will copy the data and not retrieve blank lines?
We tried to use the same formula we used for the other tabs, but could not get it to work. We figured the easiest way was adding the formula above to the spreadsheet.
Any help is greatly appreciated.
Bookmarks