Ismael
08-02-2005, 01:15 AM
Hi to all,
I have 2 questions regarding the file attached.
So the first one is how can I delete empty rows automatically for example whit a macro.
I already see one post of the forum that talk about this question but doesn?t work in my case, and I try to adapt to my question but without success.
The second question is:
In the attached file you guys can see that in the column B I have a cell that contain the word ?Data? for example cell B4, B31, 56, etc.
What I pretend is every time that I find this word I want to put in right cell (for example C4, C31, C56, etc) the value that is in the cell C3, C30, C56, etc.
I don?t now if you guys will understand this doubt, but if you have any doubt please let me now ok?
Best regards,
Ismael
I have 2 questions regarding the file attached.
So the first one is how can I delete empty rows automatically for example whit a macro.
I already see one post of the forum that talk about this question but doesn?t work in my case, and I try to adapt to my question but without success.
The second question is:
In the attached file you guys can see that in the column B I have a cell that contain the word ?Data? for example cell B4, B31, 56, etc.
What I pretend is every time that I find this word I want to put in right cell (for example C4, C31, C56, etc) the value that is in the cell C3, C30, C56, etc.
I don?t now if you guys will understand this doubt, but if you have any doubt please let me now ok?
Best regards,
Ismael