Search a row, extracting data from filled cells

[b^d]

Thanks in advance to anyone who can help me with this problem . . .

Let me say that I have little experience creating complex Excel formulas/macros but I have previous programming experience. I know I can solve this problem but could use some guidance since this is work related and I need to get this done in a timely fashion.

I need to search specific row in spreadsheet about 30 cells in length starting at first cell. Information found in this spreadsheet will be place in another spreadsheet where this formula resides. Here’s the logic of the function:


-is a cell empty?
-if yes
- move to next cell in row and return to above is-cell-empty query
-if no
1) create a new row in another spreadsheet
2) take data out of current cell position and place it within the newly created row at specific points
3) derive the column position for the current cell and move to a specific row in the current column
4) take data out of this new cell address and place it within the newly created row
5) return to previous cell position
6) move to next cell in row and return to above is-cell-empty query
-continue this loop until the 30th cell is reached

Is this sort of thing possible?

[venkat1926]

you use word "specific" what is the specific row or column . Where do you want the cell entry to be copied . If you mean the same row and column in the new sheet as in original sheet l then it is ok. clarify.

this can be done if clarified.
you can loop through the first cell to 30 the cells along the row selected by you.

give two examples.

[JBeaucaire]

Click GO ADVANCED and use the paperclip icon to post up a sample workbook. The sample should have a reasonable amount of "sample data" and a mockup of your desired results on another sheet so we can see the goal.