Macro to fill value in one of the three cells

[aadeshgandhi]

Hello,
I have data in a cell (Y2) that I would like to be copied in either one of three defined cells. If the first cell already has a value then it should go to the second one, if second is populated too then it should go to third. If third is filled up then it should display an error message.



Thanks,
Aadesh Gandhi

[mehmetcik]

This needs a simple macro

How would you want to trigger the macro.

[aadeshgandhi]

This needs a simple macro

How would you want to trigger the macro.

This is a small bit of what I want to do with the sheet, I have the main macro setup. I was plannig to plug this into the main macro.

[aadeshgandhi]

This needs a simple macro

How would you want to trigger the macro.

These are the three cells what I want the values to be populated

Please Login or Register  to view this content.

[mehmetcik]

You could use Something like this:-

Please Login or Register  to view this content.

Enjoy

[aadeshgandhi]

You could use Something like this:-

Please Login or Register  to view this content.

Enjoy

Works great! Thanks!

[aadeshgandhi]

You could use Something like this:-

Please Login or Register  to view this content.

Enjoy

Mehmetcik,
Now I am trying to paste the value in a particular column, where number of rows is not defined. The logic is again same if first cell is filled up, go to next. In this case the starting cell is E25. How should I edit the code?


Thanks,
Aadesh Gandhi

[aadeshgandhi]

You could use Something like this:-

Please Login or Register  to view this content.

Enjoy

Mehmetick,
I am using code but but the data is pasted in CF2, CF43 and so on. I want the data to be pasted starting at CF96 and then moving down one row at a time how can I edit this?

Please Login or Register  to view this content.

Thanks,
Aadesh