enigmahack
Board Regular
- Joined
- Jun 7, 2005
- Messages
- 96
I don't know if excel can do this without VB, but I basically have 2 forms.
Form A has a column that is going to basically retreive data.
Form B has columns of data, and IF the data exists in that row, it has a 1 in row J in that form.
Basically what I want to do is "If the #1 exists at the end of the row, copy that row into the next free space under Form A"
*So that it only copies over values that exists, so I don't get a whole bunch of #N/A*
Any ideas on how you might be able to do this?
Thanks in advance!
Form A has a column that is going to basically retreive data.
Form B has columns of data, and IF the data exists in that row, it has a 1 in row J in that form.
Basically what I want to do is "If the #1 exists at the end of the row, copy that row into the next free space under Form A"
*So that it only copies over values that exists, so I don't get a whole bunch of #N/A*
Any ideas on how you might be able to do this?
Thanks in advance!