St Vitus Dance
New Member
- Joined
- May 17, 2014
- Messages
- 15
Hi All,
I have data in one tab that I paste in from an export daily. The number of columns is always the same but the rows are always different.
If a cell in column V in tab 2 is blank, I want to be able to extract the data from each cell in that row into tab 1. If the cell in column v in tab 2 isnt blank i dont want it to be copied in.
Also, as the number of rows in tab 2 can vary, id like to have the formula descending to cover for a few hundred entries just in case. I'd like tab 1 to look tidy so if there is no data to be returned that a 0 or N/A# etc isnt returned.
Is this possible? Would it be an IF, MATCH, INDEX formula i would have to have pasted into the cells in tab 1? If so, would anyone be able to recommend a formula to help?
Thanks all, appreciate any help
I have data in one tab that I paste in from an export daily. The number of columns is always the same but the rows are always different.
If a cell in column V in tab 2 is blank, I want to be able to extract the data from each cell in that row into tab 1. If the cell in column v in tab 2 isnt blank i dont want it to be copied in.
Also, as the number of rows in tab 2 can vary, id like to have the formula descending to cover for a few hundred entries just in case. I'd like tab 1 to look tidy so if there is no data to be returned that a 0 or N/A# etc isnt returned.
Is this possible? Would it be an IF, MATCH, INDEX formula i would have to have pasted into the cells in tab 1? If so, would anyone be able to recommend a formula to help?
Thanks all, appreciate any help