Hi,
There can be data anywhere in the sheet
If column K is greater than 60 then make it 60
& if column K has data with decimal then remove all the data from decimal
Macro I will put in this file only & sheet name will be changed
Hi,
There can be data anywhere in the sheet
If column K is greater than 60 then make it 60
& if column K has data with decimal then remove all the data from decimal
Macro I will put in this file only & sheet name will be changed
Something like below.
First select the range that you want to apply the operation to... and run the code.
Please Login or Register to view this content.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
or
Please Login or Register to view this content.
Or simply...
Or If formulas to values then...Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by sintek; 05-22-2020 at 12:30 PM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Thnx Vraag en antwoord,sintek ,CK76 for soving this problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks