Fill Column based on Data in Column A

**sm789** · 03-28-2016, 09:37 AM

Dear all,

My problem is as follows:

- I have multiple sheets in my workbook;
- The number of rows in each sheet differ;
- Column A has serial numbers;
- Cell B6 has Text;
- I would like to copy the text in B6 to all cells in B column as long as there is any data in corresponding cell in Column A.
- I put together the below code from two three other suggestions on forums;
- For some reasons, this only works on the active sheet and not on all sheets.

Please help.

Thank you

Please Login or Register  to view this content.

**Greg M** · 03-28-2016, 11:02 AM

Hi there,

I have to go out now, so here's an untested knee-jerk response, but it might help - try using:

Please Login or Register  to view this content.

Please let me know how you get on.

Regards,

Greg M

**sm789** · 03-28-2016, 11:27 AM

Thank you Greg.

Same outcome. It just does it on the active sheet.

Regards,
Sam

**Greg M** · 03-28-2016, 05:28 PM

Hi again,

Many thanks for your prompt feedback.

Sorry - posting without testing is never a good idea

The dreaded "non fully qualified references" strike again!!!

Try:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

**sm789** · 03-28-2016, 09:30 PM

Hi Greg!

Thank you very much! It works beautifully.

Can I ask a follow up question - is there a way to make selection of B6 and column B dynamic? I would like the macro to come up with a msg box asking me which column to populate and the first cell in that column with text.

Best regards,
Sudhir

**Greg M** · 03-29-2016, 07:42 AM

Hi again,

Many thanks for your feedback.

The following code should do what you need - it contains ErrorHandling and data validation checks that weren't included in the previous version:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

**sm789** · 03-30-2016, 12:16 AM

Thank you Greg! You are awesome!

**Greg M** · 03-30-2016, 10:09 AM

Hi again,

Stop - you're making me blush!

Many thanks for your feedback - glad I was able to help.

Best regards,

Greg M

Fill Column based on Data in Column A

LinkBack

Thread Tools

Rate This Thread

Display

Fill Column based on Data in Column A

Re: Fill Column based on Data in Column A

Re: Fill Column based on Data in Column A

Re: Fill Column based on Data in Column A

Re: Fill Column based on Data in Column A

Re: Fill Column based on Data in Column A

Re: Fill Column based on Data in Column A

Re: Fill Column based on Data in Column A

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to fill an array with values in column C based on Column D date value of Today

Fill Down Data Based on Contents of Another Column

[SOLVED] Fill a cell in Column B based on the text in Column A using a table on sheet 2

Fill cells in one column based on specific words or letter from another column

Insert column and fill column upto where data is in previous column

Auto fill column A sequentially for a given range, based on drop down selected in column D

Fill down formula based on another column data

Bookmarks

Bookmarks

Posting Permissions