finding last empty cell and filling data to the left

[ali]

Hi guys,

I have a problem.

My data in row 3 starts from different cells all the time,i.e.,
sometimes from g3, fg3, etc.

i have some data in row 4 (the number os values here is also
variable) which i want to place right of where the data starts in
row3,e.g,

row3

blank blank blank blank blank blank blank blank 4 2 3

row4

1 2 3

After the operation I want row3 to look like this

blank blank blank blank blank 1 2 3 4 2 3

I hope I have been able to explain the problem.

Would really appreciate any help and guidance.

Thanks

ali

 

[ali]

Hi guys,

I have a problem.

My data in row 3 starts from different cells all the time,i.e.,
sometimes from g3, fg3, etc.

i have some data in row 4 (the number os values here is also
variable) which i want to place right of where the data starts in
row3,e.g,

row3

blank blank blank blank blank blank blank blank 4 2 3

row4

1 2 3

After the operation I want row3 to look like this

blank blank blank blank blank 1 2 3 4 2 3

I hope I have been able to explain the problem.

Would really appreciate any help and guidance.

Thanks

ali

sorry mates,

I want the data to appear left of the data in row 3. My apologies.

ali

 

[Rick Rothstein \(MVP - VB\)]

Wow, you really don't pay attention to the responses you get, do you? I
posted a detailed response of why cross-posting (as opposed to
multi-posting) is the way to ask your questions in more than one newsgroup,
and that post even showed you how easy it is to perform a cross-post, and
here you are multi-posting your current question. Any particular reason why?

Rick

 

[ali]

Wow, you really don't pay attention to the responses you get, do you? I
posted a detailed response of why cross-posting (as opposed to
multi-posting) is the way to ask your questions in more than one newsgroup,
and that post even showed you how easy it is to perform a cross-post, and
here you are multi-posting your current question. Any particular reason why?

Rick









- Show quoted text -

hi rick

could u please explain how can i cross post

ali

 

[Rick Rothstein \(MVP - VB\)]

Wow, you really don't pay attention to the responses you get, do you? I

could u please explain how can i cross post

Here is the post I provided earlier that I refered to... how to do
cross-posting, and the explanation of why it is the better way to go, is
included inside of it...

From a post by Jeff Johnson (in the compiled VB newsgroups):

"You have posted this question individually to multiple groups. This is
called Multiposting and it's BAD. Replies made in one group will not be
visible in the other groups, which may cause multiple people to respond to
your question with the same answer because they didn't know someone else
had already done it. This is a waste of time.

If you MUST post your message to multiple groups, post a single message and
select all the groups (or type their names manually in the Newsgroups field,
separated by commas) in which you want it to be seen. This is called Cross
posting and when used properly it is GOOD."

Some additional comment previously posted by me:

"You may not see this as a problem, but those of us who volunteer answering
questions on newsgroups do see it as a problem. You can't imagine how
annoying it is for a volunteer to read a question, research background
material, test sample code and then formulate and post an answer to the
original question only to go to another newsgroup and find the question
posted and ALREADY answered over there. On top of that, if you cross-post
your question, all of the readers in all the newsgroups it is cross-posted
to see both the original question and all of the answers given to it. This
is beneficial to you because then we can add additional material to, add
clarification to, as well as add additional examples to an answer you have
received previously... that means you end up with a more complete solution
to your problem. This is a win-win situation for all of us."

Rick