B
Bob
I have a excel spreadsheet consisting of several tabbed worksheets. I
want to write a macro that will store some information from one
worksheet in another.
For every row in a particular range of worksheet2: if there is something
stored in column 7, then copy the contents of the cells in columns 1 and
3 to the next empty row of worksheet1, storing in columns 1 and 2.
Something like:
repeat for rows from 10 to 200 of worksheet2
if the cell at that row, column 7 of worksheet 2 is not empty then
goto the next empty row of worksheet1 and store some info
store contents of worksheet2: row,1 in worksheet1: next empty row, col1
store contents of worksheet2: row,3 in worksheet1: next empty row,
col2
I hope I have made this understandable. Thanks in advance for any help!
Bob.
want to write a macro that will store some information from one
worksheet in another.
For every row in a particular range of worksheet2: if there is something
stored in column 7, then copy the contents of the cells in columns 1 and
3 to the next empty row of worksheet1, storing in columns 1 and 2.
Something like:
repeat for rows from 10 to 200 of worksheet2
if the cell at that row, column 7 of worksheet 2 is not empty then
goto the next empty row of worksheet1 and store some info
store contents of worksheet2: row,1 in worksheet1: next empty row, col1
store contents of worksheet2: row,3 in worksheet1: next empty row,
col2
I hope I have made this understandable. Thanks in advance for any help!
Bob.