As two times tried to get an answer:
how do You manage those missing rules?
Without an answer ... it's really a challenge to offer more than those ... Your given rules.
Calypso88d
I referred only and only Your given file.
otherwise ...
... how do You manage those missing rules?
It'll be a challenge to offer any kind of solution if something basic details are missing.
... the only two rules, yes
Means that only those three labels and only those four columns can have colors - others ... no!
You haven't use third label ... that means - no color.
As well as Apples won't have color.
Esrasnatas
About Your
Dim Sht_58_Data As Worksheet
Sht_58_Data.Activate
What is She_58_Data's value?
... same as ... which sheet You would like to Activate?
Have You Googled eg Excel VBA Dim?
... to check some basic rules - how do Excel work?
Calypso88d
This thread can move to VBA Macros ( ~no need to open a new thread ).
Your I have 89 labels in the dropdown list and more than 20 columns eg Grapes, Oranges, Bananas
and Your file shows ... two rules for those colors.
Are those all rules?
if Yes then okay
otherwise ...
... how do You...
ChaCha90
You offered here csv-file.
Where do You get those datas there (in .csv-file)?
If You'll get those datas somewhere else than from ... csv-file,
then please upload here a sample Excel-file
which You should save as .csv-file with leading zeros or so.
ChaCha90
I opened Your file and it asked as below ...
I selected Don't Convert ...
It opened with leading zeros.
I saved it as .csv ...
and
Your file looks same as Your original.
Have You tested as above?
stanley thomas
Moderator Note:
These Forum Rules are for everyone:
https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/
Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a...
Artisez
About Your During the weekdays we will save a backup copy and add the...
Questions:
Could this backup procedure do automatic?
Why You or Your boss would like to apply some cells and press the button?
Solution:
That procedure could happen while opening/closing file by the code.
There...
ibrahimdaas
Your What is requered from me to do ??
#1 before posting, You read Forum Rules
#2 post Your thread
#3 follow rules
#4 be patient, others will reply then they'll have time
Your thread
It would be possible ( You could test with Your used functions ) to get differences to zero like...
Okay #1
If Your cells F2, P1 & Q1 contains texts as You wrote then there are invalid characters.
I try one more time and other way:
if You select cell F2 ... what can You see in formula in Excel formula bar?
and do same with cells P1 & Q1.
#2 Length of path & filename?
#3 Did You modify variable...
Verified means that You've checked/verified that those three values are valid for filename... as written in that Run-time error.
How long is path & filename?
Your the 1st parameter (filename) is same as Your variable filename
... it would be better to have different variable name
ibrahimdaas
As You've read from ... many Forums:
https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/
Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
If you...
aayu
Please, do not duplicate Your thread.
https://chandoo.org/forum/threads/add-filter-in-pivot-table.56409/
Continue with Your previous one.
This thread is closed now.
MrProfessor
As You've read from two sites:
Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
If you do cross-post, please put that in your post.
Also if you have cross-posted and...
So ... protection works 'too well' with Your case.
Could You create a sample Excel-file,
which shows
# what do You really would like to allow?
# what do You really would like to restrict?
Or
Could You add eg to the 1st row of that sheet values from 1 to 9999 ( = number of columns )
... and take...