Select and Move Cell

[mned]

Hello,

I am new to VBA and trying to learn as much as possible. What I am trying to do is look in column B and select the cells in column B that do not have anything next to it in Column C.

Thank you for the help, and any advice on the best way to learn about VBA would be awesome!

 

[My Aswer Is This]

Hello,

I am new to VBA and trying to learn as much as possible. What I am trying to do is look in column B and select the cells in column B that do not have anything next to it in Column C.

Thank you for the help, and any advice on the best way to learn about VBA would be awesome!

We would need more details. Each column has 1.5 million cells. So, there are going to be a lot of cells that meet this criteria.

Tell us your total objective

 

[mned]

The data would not ever go past row 100. The background to this question is to organize raw data into the format I need quickly. I have attached a brief example how the raw data comes in, and how I need it to be organized. I currently do all of it by dragging cells around.

 

[mned]

We would need more details. Each column has 1.5 million cells. So, there are going to be a lot of cells that meet this criteria.

Tell us your total objective

The data would not ever go past row 100. The background to this question is to organize raw data into the format I need quickly. I have attached a brief example how the raw data comes in, and how I need it to be organized. I currently do all of it by dragging cells around.

 

[daveG777]

So I can understand what you need, please show a sample of

A) All the columns, before anything has happened​

B) All the columns, the result​

 

[mned]

So I can understand what you need, please show a sample of

A) All the columns, before anything has happened​

B) All the columns, the result​

Hey Dave,

Here are the pictures of all columns, how data gets pulled v.s how I need it.

 

[daveG777]

Hi Mned,

I guess it wasn't a joke when a famous scientist (I wonder who it was) reputedly said that if you could come up with the right question, you'd already have the answer.

Here's what I need to see:

1. All columns, including the blank one, labeled on top. Please don't omit any relevant rows or columns.
2. The complete data; for example, I see no mention of "Title A" in the Raw Data.
3. Just in case, can you think of anything else that might be missing? Perhaps a few more descriptive words about your logic?

I think this thread is suffering from a skimpiness of necessary information for something that should have gotten a quick answer in the first place.

In my short experience reading this forum, I see highly qualified and surprisingly friendly and generous people who are eager to help. However, I think it takes away from the fun, if the person seeking advice doesn't seem to provide the necessary info up front. I think the experts want to contribute their time with thinking about formulas, functions, logic, and VBA, not about scrabbling for the basic info.

My best to you.

Dave