Replies

Steve

Thank you for the advice, but the reason I want it in the requested format is as follows:

First the speadsheets go to accounts department for upload in the system and then each BO site must get a copy of only the information applicable to them, hence the need to separate the information.

In my department I do keep all the info in one file as suggested.

Regards

Hallo again

I forgot to mention that I want to develop my macro code further to do this automatically.

Sorry for any inconvenience.

Regards

Here is the second file

Hans

Thank you. You solved my problem. Previously I tried Format | Sheet | Hide which is obviously why it did not work.

Thank you again

Regards

Kobus

Hans & Aladin

Thank you very much for the lessons.

Hans, thank you for always being available and ready to help us mere mortals.

Aladin, I agree with Hans, clever, clever!

Regards

Hans

Thank you. I agree with your argument. As you say it depends on what you want to achieve.

How could the formula be adjusted to include multiple occurrences of a number?

Regards

Not so clever. Aladin, I included an attachment in which can be seem that the formula does not always work.

I updated the formula so that you can choose in the yellow block how many “largest” numbers you want to sum.

In the first sample you can see that everything is working fine.

In sample 2 and 3 you can see that when you have the same number repeating you start to have problems.

In sample 3 it add only two occurrences of the number. You would think that since you have only one number repeating that it would add the number 10 times since it is the largest number.

Regards

Kobus

Steve

Thank you also, it always amazes me how easy it seems when you guys give a solution

Hans

Thanks again to the genius.

Regards

Kobus

Hans

As always, you show your absolute mastery over our normal mortals.

Thank you very much.

It works perfect.

Kobus

Hans

As always, you show your absolute mastery over our normal mortals.

Thank you very much.

It works perfect.

Kobus

Hans

Thank you very much. My mistake was that I did not name the sheet as Sheet.xlt, but as test1.xlt. I did however stored it in the correct folder.

After deleting the wrongly named sheet and stored it with the correct name it worked exactly as you said.

Dit help baie as daar slim ouens soos jouself is.

Regards

Kobus

Hans

Thank you very much. My mistake was that I did not name the sheet as Sheet.xlt, but as test1.xlt. I did however stored it in the correct folder.

After deleting the wrongly named sheet and stored it with the correct name it worked exactly as you said.

Dit help baie as daar slim ouens soos jouself is.

Regards

Kobus

Hans

Thank you very much more the advice. I have done that now, but it do not insert a worksheet in the existing workbook with the new formatting.

Is there any way in forcing the existing workbook to open a new worksheet with the new formatting?

Regards

Kobus

Hans

Thank you very much more the advice. I have done that now, but it do not insert a worksheet in the existing workbook with the new formatting.

Is there any way in forcing the existing workbook to open a new worksheet with the new formatting?

Regards

Kobus