Create a MACRO in Apple Numbers!

Рет қаралды 3,978

Күн бұрын

Пікірлер: 16

@Abbasfathy 3 сағат бұрын

Your tutorials are great. Please, HELP, I want to copy a cell formula to another cell and some formulas from a range of cells to another range of cells. Thank you very much.

@Jhauber19331 5 күн бұрын

I appreciate all the effort you put into providing these tutorials, they are very helpful to me. However, I had a problem with this script as written. It took me a while to figure out and I learned a lot along the way. Here's the upshot of the issue The result of this statement set theColumnLetter to name of theColumn is dependent on "Settings/General/Cell References use header names as labels". If this setting is checked(on) then the script will generate an invalid formula because the theColumnLetter value will be the value of header column name cell rather than the column letter. Can you suggest a more reliable way to extract the column letter?

@apple-a-day 4 күн бұрын

Great catch. I didn't notice the issue because I didn't have a column header. In any case I did find a workaround. I used the Address of the column instead of the name. I then converted that to ASCII so I could get the column letter. The address of the first column will always be 1 which will represent A. The ASCII value of 'A' is 65, so adding 64 to the address to get the column letter worked for me. Here's the updated code to get the column letter: -- GET THE COLUMN LETTER OF THE COLUMN set theColumnAddress to address of theColumn set theColumnAscii to 64 + theColumnAddress set theColumnLetter to ASCII character theColumnAscii AppleScript has a built in function to convert an number to text: ASCII character Hope this solve the problem on your end as well. Thanks for the question and thanks for watching!

@dongio-t9w 5 ай бұрын

Really very informative and useful. I tried it and it works perfectly. It would be great to see more of them. Thank you

@apple-a-day 5 ай бұрын

That's great to hear!! I'll definitely be adding more in the future. Thanks for watching!

@alanmclean1399 5 ай бұрын

Clever stuff and really useful! I’ll definitely give this a try

@apple-a-day 5 ай бұрын

Thanks and Thanks for watching!

@egiziaphoto Ай бұрын

Hi! Can you help me with something I'm stuck since october of last year? I've got this list of links of job. I need to create a formula that search for some specific words into the link and return a different text for every specific word it finds. Basically, if in the link there are the words "basket" or "naples" or "pozzuoli" or "flavio", it has to return "basket", if there are "puteolana" or "calcio" or "diavoli", then it has to return "calcio". I tried the or function with ifs, but it doesn't work! Please HELP, I'm desperate!

@apple-a-day Ай бұрын

Hi there! Thanks for the question. You should be able to achieve this with REGEX and SUBSTITUTE. I did a quick test and it seemed to work (assuming I'm understanding your question correctly). SUBSTITUTE(A2, REGEX("(naples|basket|pozzuoli|flavio)",FALSE), "basket") So the SUBSTITUTE function will take the contents of a cell, in this example, cell A2. And then it wants to do a find and replace - the Find portion uses the REGEX command (a Regular Expression command). REGEX can be really confusing and hard to learn but it is very powerful. The actual REGEX command is in the quotes inside the REGEX(): (naples|basket|pozzuoli|flavio) The round brackets tell REGEX to look for the whole words. The | symbol acts as a separator between each word and also works like an OR... to it's trying to find a match for napes OR basket OR pozzuoli OR flavio. If any of those words are found then the SUBSTITUTE function replaces it with "basket" Note that the FALSE parameter within the REGEX function tells REGEX that it is not CASE SENSITIVE. I hop this helps you out. Let me know if this works for you. Thanks for watching!