# Posts by dangle

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

• ## Random Text for List Based on Sum Criteria

Re: Random Text for List Based on Sum Criteria

No problem. Glad to be of some help.

• ## Copy row, insert twice and change cell in each row to different value - insert issue

Re: Copy row, insert twice and change cell in each row to different value - insert is

Like Patel, I am not entirely sure what you are after but using 'ActiceCell' and 'Select' is probably not the way to go with this. It is likely to lead to strange results:

Give this a try:

• ## Random Text for List Based on Sum Criteria

Re: Random Text for List Based on Sum Criteria

Hi Zach

This will pick one of the values randonmly and sum until the total is within the range. I guess there could be an argument on whether it is truly random but it might work for your purposes. Your data should start in cell "A1".

• ## [SOLVED]Leveling Macro

Re: Leveling Macro

Hi scambug

Give this is a try. If there are more levels of children it may need adjusting:

• ## Compare 2 Excel Sheets Line by Line and Highlight all new data on a new sheet

Re: Compare 2 Excel Sheets Line by Line and Highlight all new data on a new sheet

excelhelp2

Yes it is possible but I recommend you use jindon's code since I'm not going to be able to improve on that.

• ## Compare 2 Excel Sheets Line by Line and Highlight all new data on a new sheet

Re: Compare 2 Excel Sheets Line by Line and Highlight all new data on a new sheet

If I have understood correctly, this should highlight anything removed in blue and anything added in red. Give it some testing.

• ## Combine multiple records onto 1 row based on unique name/surname in the first column

Re: Combine multiple records onto 1 row based on unique name/surname in the first col

Hi Anita

In case you haven't resolved this yet. The data should start in A1.

• ## Move multiple columns to multiple rows

Re: Move multiple columns to multiple rows

No problem. Glad it's working for you.

• ## Numeric wildcard

Re: Numeric wildcard

A beast but very well thought through.

A possible, as a UDF:

• ## Move multiple columns to multiple rows

Re: Move multiple columns to multiple rows

This will test to see if you have the correct number of columns for each set of names.

• ## Move multiple columns to multiple rows

Re: Move multiple columns to multiple rows

You had two extra columns in the last sample you sent me. Did you delete those?

• ## Runtime error 424

Re: Runtime error 424

Have you created controls for 'num_form_ok' and 'num_form_cancel'? I think this may be the likely cause.

• ## Reconciling A Master Worksheet Against Three Other Worksheets

Re: Reconciling A Master Worksheet Against Three Other Worksheets

It's hard to fully appreciate this without seeing an example. Why can't you upload something, even a mock-up of the data?

• ## Move multiple columns to multiple rows

Re: Move multiple columns to multiple rows

OK. This one you can change to suit the number of household columns and the number of columns per person. Seems to work on what you gave me once I deleted the last two columns but let me know.

• ## Move multiple columns to multiple rows

Re: Move multiple columns to multiple rows

What about column R? What is the pattern for each name to be transposed, or how many columns for each name should be transposed?

• ## Move multiple columns to multiple rows

Re: Move multiple columns to multiple rows

It should work for additional columns as it is. Give it a try and let me know. The only thing to change would be if you have more than ten names to transpose. In which case change:

Code
``ReDim b(1 To UBound(a, 1) * 10, 1 To 6)``

to:

Code
``ReDim b(1 To UBound(a, 1) * (UBound(a, 2) - 4) / 2, 1 To 6)``
• ## Compare data set 1 with data set 2. Add to data set 2 if not found

Re: Compare data set 1 with data set 2. Add to data set 2 if not found

No problem. Glad it saved you some time and thanks for your comments. Let me know if I can help to explain.

• ## Compare data set 1 with data set 2. Add to data set 2 if not found

Re: Compare data set 1 with data set 2. Add to data set 2 if not found

Omar

It is always best to upload a sample of data so that we can clearly understand your requirements. This may help but you will need to test it yourself as I am not creating a workbook for you.

• ## Move multiple columns to multiple rows

Re: Move multiple columns to multiple rows

I am not sure about a formula but a possible marco:

• ## Compare 2 workbook using Scripting.dictionary(Whats wrong in my code?)

Re: Compare 2 workbook using Scripting.dictionary(Whats wrong in my code?)

Can you provide the data that this code is running on? Where is it failing?