find first empty cell in range and then copy from another workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rachitm@gmail.com - 27 Jan 2007 23:32 GMT

I am looking for a formula function or a vba code where:

- In workbook1 find the first cell that is empty between range A7 -
A10,
- In workbook2, in Range G10- G13: find the word "Day1".
- If the word "Day1" exists in cells G10 or G11 or G12 or G13, copy
the particular cell or cells where "Day1" exists to the first found
empty cell or cells in range A7-A10 in workbook1.

Lets suppose cells A8, A9, A10(workbook1) are empty cells, that means
A8 is the first empty cell.
And G10,G11,G12, G13 (workbook2) have the word "Day1"
Then,
Copy cell G10 into cell A8
Copy cell G13 into cell A9
Copy cell G14 into cell A10

Please let me know if this explanation is confusing.... and I can try
explaining again.

Appreciate all help!

Reply to this Message

rachitm@gmail.com - 27 Jan 2007 23:39 GMT

PLEASE SEE THIS QUESTION, DISREGARD THE ONE ABOVE. SORRY ABOUT THE
CONFUSION:

I am looking for a formula function or a vba code where:

- In workbook1 find the first cell that is empty between range A7 -
A10,
- In workbook2, in Range G10- G13: find the word "Day1".
- If the word "Day1" exists in cells G10 or G11 or G12 or G13, copy
the particular cell or cells where "Day1" exists to the first found
empty cell or cells in range A7-A10 in workbook1.

Lets suppose cells A8, A9, A10(workbook1) are empty cells, that means
A8 is the first empty cell.
And G10,G11,G12, G13 (workbook2) have the word "Day1"
Then,
Copy cell G10 into cell A8
Copy cell G11 into cell A9
Copy cell G12 into cell A10

Please let me know if this explanation is confusing.... and I can try
explaining again.

Appreciate all help!

On Jan 27, 6:32 pm, rach...@gmail.com wrote:

> I am looking for a formula function or a vba code where:
>
[quoted text clipped - 17 lines]
>
> Appreciate all help!

Reply to this Message