Thanks! No, it is viewers like you that support me and I am grateful for that!

Do you mean when printing? See kzfaq.info/get/bejne/rZ2Hi5ObvciuiYE.html

It has them now!!! 🥳🎉

@@mauricioflores3732 thank you

Yes, you can refer to any cell using strings created inside formulas. Look at the INDIRECT function for instance. But I would caution against having weekly sheets. Treat your data like a database and have it in one long table. If you need to display weekly information, have it pull from that table. See this for an example: kzfaq.info/get/bejne/qMWChdOLzbunqoU.html

To find duplicates, see kzfaq.info/get/bejne/fpaGpdqp0MvPm2g.html

Not sure what you mean. If you want to copy data from one table to another, copy and paste should do it.

@@macmost I have a spreadsheet of names and paste and copy does work. I then use an "if" formula to find duplicates. I then use that data sheet to divide the names into groups on another sheet. I use a filter to group the names and then sort the names into ascending order based on first name. The problem is that the next time I want to do this the filter and sort does not work. Is this because the data changes each time I do the "if" formula?

@@timthompson8852 Sounds pretty complex. It is hard for me to grasp the whole picture here with your description, sorry. Just keep working at it, or get some firsthand help if you can't figure it out.

The date feature could show you that I would think.

You should keep data together in one table. If you have divided it up among many tables on different sheets, then you'll just need to create a new table and reference the results from each table.

The SUM function is for a range of cells. If you need to get the SUM of a range in one table and add the SUM of a range in another table, you need two SUM functions. So: =SUM(first range)+SUM(second range)

@@macmost Thank you for your reply Garry! I’m trying to make a SUM from two specific cells from different tables. Not a range of cells.

@@Rubahell Oh, so that's not a job for the SUM function at all. That's just addition. like =A1+A2

@@macmost Simple as that! Thank you!

Numbers is Mac/iPad/iPhone/Web but the web version is more for collaborating. I wouldn't use it instead of an app.

SUMIF gets the sum of a range of cells IF a condition is met. Sure you could do a series of + operations, but that would mean manually do it each and every time, manually selecting which cells to add. The whole point of using a computer for this is to make things easier for you. You could add new rows with new dates and SUMIF will figure out which ones match those dates. Read the help info for SUMIF and watch kzfaq.info/get/bejne/gbtdobyJtJ3KgJs.html

iPad Numbers has much of the same functionality, yes.

No, you can't link documents like that. As for one-cell tables, make sure you turn off the header row.

@@macmost Thank you Gary.

Check your formulas carefully. Must be a mistake in there.

They are in order of which in on top of the other. Use the Arrange menu and the first 4 items there to move the tables in front of or behind the others.

Sheet themselves? No. You just drag them to reorder them as you like. If you have so many sheets that this is a problem, I'd encourage you to rethink your data organization.

Do you mean combine from two documents into one document with multiple sheets? Copy and paste is how you do it. Copy a table from one document, paste it into a new sheet in your other document.

See kzfaq.info/get/bejne/rZ2Hi5ObvciuiYE.html

There's no easy way. But you can always open a second temporary document, copy and paste the other table to it, and then copy the information from that temporary document to the original one.

Use multiple SUMIF functions and add them together.

Not quite sure what you mean, but you can use Option+Return to insert a new line into a cell.

File, Export To, Excel.

No way to do that.

Not sure what you are looking for. The table needs to shift as you scroll or you wouldn't be able to see more of it. It definitely does this in Excel also, as you need to be able to see more of it there too.

@@macmost In some Excel templates, like Workbooks, they give you the option for an "endless" table that fills the entire sheet to input data in a spreadsheet. In Excel, when I scroll up/down, the columns scroll in a straight path without shifting side-to-side. And if I scroll left/right, the columns move in a straight path without shifting up and down. So the table stays in place while only the columns and rows move when you scroll but not the table itself. Also, in Numbers, if you scroll to the far left, you'll see a vertical gray bar on the left edge of the window and if you scroll to the very top, you'll see a gray horizontal bar just underneath the toolbar. It's like the table bounces around instead of being static. I wish Numbers had a preference to have a table that scrolls in a linear fashion rather than like a rubberband. This can be slightly annoying when I'm trying to target specific cells, but the slightest touch of my mouse causes the table to bounce around. I thought holding down the shift key would help me to scroll linearly, but it didn't help. The best way to see this is to open a Numbers and Excel document side-by-side and try scrolling. There's something about the fluidity of Numbers' scrolling compared to the rigidity of Excel's scrolling. Both have their place, I just wish Numbers could let you choose between the two. Thank you for all the great content.

I'm guessing it isn't a freeze, but you just are trying to use a header row or column as a place of regular data. See kzfaq.info/get/bejne/jMllfdCoqLfNdp8.html to learn about header rows and columns.

Not sure what you mean. If you have two tables on a sheet and want to move one to another sheet, then use Cut and Paste to do so.

Links? I'm not sure what you mean.

Not sure what you are asking. If you copy and paste data from one table to another you are duplicating the data, yes. I'm not sure logically how you want to duplicate and also not duplicate.

@@macmost I figured it out... thanks for your comment....

Not sure what you mean. Ask with more details here: macmost.com/ask

Templates are for documents, not sheets. But you can always create a new document with a template, then copy and paste the tables and other elements in the sheet you want from one document to another.

Why do you have dozens of sheets? Are you dividing up like data across sheets, maybe? Like one month or year per sheet. Maybe try a different strategy and put all like data in one table on one sheet (like a database) and use other sheets to analyze that data and do other things.

First, I would hide columns in the table if you want to preserve information in a table without seeing it. Try that instead, it is much cleaner and easier. Otherwise, you can always select the table or just some cells and go to the Format sidebar, Cell, then change the Fill to a color fill. Choose any color you want, like a solid white.

@@macmost That hide suggestion did the trick! Thank you so much!!!

Do you see the tab at the top with the first sheet? Is it not next to that? Try adding it again.

Try it. You can export from Numbers to Excel. You have options then on what to do with tables. You'll see. But I do suggest that if you are working on a document with others that are using Excel, that you use Excel too. Same for any app.

Do you mean the ability to put a table inside the existing table? That's an interesting function, but not really what I am talking about here.

@@macmost No, this is more like designating a portion of the worksheet at a "Table" either by Insert>Table or by placing cursor inside the range you want as a Table and pressing Ctrl-T. That way I've actually placed several "Tables" on a single Sheet.

@@TArnoldFerguson When I try those things I get a table inside the main table, not a separate table like in Numbers.

@@macmost I think this is a matter of semantics. What you're calling a "main table" does not function like a "Table" (I'll use upper- and lower- case t's to differentiate. A "table" is essentially a worksheet with all the math and logic functions of spreadsheets. A "Table" has additional properties (like being nameable, pivot tables. etc.). I guess I'd say that a Table is like a super-table. I'm really talking above my abilities here, so forgive my meager attempts at an explanation.

Pull data? Live? Numbers can't do that alone. You'd need some scripting or an app to handle that.

@@macmost Does numbers support deep linking?

@@merlingrim2843 What do you mean by "deep linking" exactly? An example?

@@macmost Check out stack overflow. Search for issue-deep-linking-to-ms-excel-from-ios-app. iOSAcademy also has a YT video on the subject.

@@merlingrim2843 That came up with an article dealing with Swift that at a glance doesn't seem to apply to Numbers spreadsheets. Tell me in a sentence or two what you want to DO here.

What else besides adding a new sheet have you tried? Can you edit cells? Is there any kind of message when you try?

@@macmost Only zoom & collaborate nothing else in tool bar. Can also tap print set up & text on far right. I decided to make a new one, I noticed it looks updated. Could it be because it’s an old version?

@@momovaryacting8798 Not sure what you are seeing, sorry. Maybe post a screenshot somewhere I can see? Or, use the contact form at macmost.com and you can email me a screenshot.

Maybe using Tabs instead of separate windows is what you are looking for?

When you go to the Print preview (Command+P) there is a setting there for "This Sheet" or "All Sheets."

Select the text (inside the cell) and then use Format, Add Link.

@@macmost thanks Gary.. 🙏🏽

There are no quick buttons to do either of those. But you can use formulas to do them. For instance: kzfaq.info/get/bejne/fpaGpdqp0MvPm2g.html

What is in A1 and what is in B1? When you select A1, does it show "Actual" and the number at the bottom left. How about B1?