How remove unused macros from Numbers spreadsheet?
How can I remove old unused macros from a legacy spreadsheet?
MacBook, Mac OS X (10.6.7)
How can I remove old unused macros from a legacy spreadsheet?
MacBook, Mac OS X (10.6.7)
Hi olsenjo,
Thank you for the Gold Star!
I do not think that the FIND function is what you need.
Use the SUMIFS function to "pull" data that match multiple criteria. Here is an example of a subset of a 'Very Large Database' and a small table with a purpose.
Formula in C2 (and Fill Down)
=COUNTIFS(Very Large Database::A,A2,Very Large Database::B,B2,Very Large Database::E,C$1)
That will count all the "Good" values in the Very Large Database, Column E ("Health") that match all the IFs, including the absolute reference to Good in the second table C$1
Congratulations to Jack for helping you, and good luck with your vineyards!
Regards,
Ian.
SGill, thanks for your interest. I opened the spreadsheet in question on my iPad, saw a different view of the info, and believe I have figured it out. Simply deleted all the info in columns outside the summary view. As background, someone else developed the spreadsheet originally in MSExcel. It is a spreadsheet that identifies all the grape varietals in a vineyard and gets updated regularly as vines die, or get replaced, or we get better guesses as to the grape variety at a particular location (i.e.: Row 6 Vine 17.) Macros were set up to count the number of vines of a particular variety (i.e. Carlos or Vitis Noble) in the spreadsheet and, by extension, in the vineyard. Since I was unfamiliar with the macros that had been set up to count each varietal, I simply effected manual updates and manual counts via "Find" to determine totals as the information got updated. Since I have been doing things manually, I found the "macro" info distracting. A "find Carlos" search would return results in columns outside the "Summary" view of the spreadsheet. A distraction for my neanderthal manual manipulation of the data. Next step may be to figure out how to write and insert "count" macros as the original author intended.
Hi olsenljo,
Macros were set up to count the number of vines of a particular variety (i.e. Carlos or Vitis Noble) in the spreadsheet and, by extension, in the vineyard.
In Excel, Macros belong to that document. Numbers does not have Macros, but can use external Applescripts. It is years since I used Excel (and I was never proficient in the use of Macros) but I doubt that opening an Excel document in Numbers would import Macros.
Perhaps you mean formulas? Most Excel formulas will translate to Numbers formulas. For example, a formula to count the number of vines of each variety may make use of the COUNTIF function or perhaps the SUMIF function.
Translation from Excel to Numbers is not perfect. The two spreadsheet apps have different approaches. For example, Numbers uses several tables, each with a purpose. A small Numbers table might "pull" relevant data from a large database.
Let's start from the beginning. Please reply with your overall aim and an illustration (screen shot) of how the raw data were arranged in Excel. It may be possible to suggest how you can rescue what the original Excel author intended, or to show how to use the raw Excel data in a Numbers document.
Regards,
Ian.
Thanks for the info. Last time I used Excel was 20 yrs ago. The term "macros" came from Excel running on Windows '95/'98 back in the day. I've never had to learn, or use, spreadsheets with any great degree of sophistication. Knew they were capable of all manner of things, but usually used specialty software for financial number crunching and the like. We drew a map of the community vineyard we inherited. The vineyard rows lent themselves to depiction in columns on a spreadsheet which could be revised and updated readily. One of our residents converted the data and built in counting functions. I got Numbers with a newer MacBook Pro I bought and imported Jack's spreadsheet, but didn't want to send new data back to Jack every time something changed or we learned more. Just edited cells and counted varieties manually. "Find" gave me a count, but it wasn't useful because of extra data in legacy COUNTIF tables/columns/whatever carried in from Excel. Being too lazy to actually learn Numbers, I wanted to just clean out the bits that threw off the count, but didn't know enough to even reliably find those hidden parts which is where my question originated. What I really needed was to know how to navigate to "hidden" bits. I'm good now. I've deleted the bits that interfered with my manual updates and will get with the creator of the Excel document for a tutorial on how he set up what he built before I go back and try to learn more about Numbers, but thanks to everyone for trying to help an old man who didn't know enough to even properly ask a question to get the answers needed. Thanks again.
Can you give more specifics? What do you mean by "macros"?
SG
How remove unused macros from Numbers spreadsheet?