J
J Marro
I am trying to figure out the formula to do the following:
I have a set of data (some text, some numbers) that I paste to worksheet1.
There is much more data pasted to worksheet1 than I need but because of the
format it is easier to capture all the data with Copy and let Excel filter
by which cell the data occupies. Then I have worksheet2 with formulas that
pull data from worksheet1 and put it in specific columns in worksheet2. I
need a formula that will either:
1) automatically move the desired data from worksheet1(identified by
specific cells) to the next set of empty cell in worksheet2 or
2) a macro I can assign to a button that will move the desired data
(identified by specific cells) from worksheet1 to the next set of empty
cells in worksheet2
I am designing this for Excel 97 but need it compatible across later
versions which I don't see as a problem.
Thanks in advance,
I have a set of data (some text, some numbers) that I paste to worksheet1.
There is much more data pasted to worksheet1 than I need but because of the
format it is easier to capture all the data with Copy and let Excel filter
by which cell the data occupies. Then I have worksheet2 with formulas that
pull data from worksheet1 and put it in specific columns in worksheet2. I
need a formula that will either:
1) automatically move the desired data from worksheet1(identified by
specific cells) to the next set of empty cell in worksheet2 or
2) a macro I can assign to a button that will move the desired data
(identified by specific cells) from worksheet1 to the next set of empty
cells in worksheet2
I am designing this for Excel 97 but need it compatible across later
versions which I don't see as a problem.
Thanks in advance,