This may have been addressed before, but I could not find anything that made sense to me (I have been a long time excel user). I am new to open office and I have an interest in trying to work with it. Mainly because my employer is using it. So, I work at a cab company and have created a spreadsheet to help track my daily drops and such. What I want to do now is create a separate spreadsheet to summarize and calculate what I have earned each week.

Yes, I can just manually copy and edit each reference, but I'd like to be able to create a formula that can access the spreadsheet. All I'd have to do is just have the name of the sheet in a cell, have the formula reference it and pull up the data. Assuming you are working on Sheet2 and want to reference the content of cell B7 of Sheet1, this is done by Code: Sheet1.A7 To get the same reference taking the sheetname 'Sheet1' from cell A1 where it was entered as text, you can use Code: INDIRECT(A1&'A7') If you want to reference the cell in the 12th column of the 5th row of the sheet whose name was placed into cell A1 of the current sheet, you can use Code: OFFSET(INDIRECT(A1&'A1');5-1;12-1) and so on. To advise more precisely I would need a more precise explanation about what you try to achieve. What is a good free program for mac that does visio. As you described yourself as a former Excel user you may explain your goals by giving the formulas you would expect to work in Excel delivering the results you want.

These free MAC antivirus software provide you the best virus protection for MAC. You can use these software to scan for viruses on MAC Also check out the list of Best Free Antivirus Software For Windows, Free Software To Remove Viruses, and Best Free Internet Security Software. N/A Best Free Antivirus AVG Security for Mac Avast Security for Mac Pro Mac Internet Security software costs on average between $60 and $90, with the best. Kaspersky Internet Security for Mac. Mac protection from a well known brand. Avast Free Mac Security goes the extra mile to protect your Mac with an unusually lengthy feature list. The core antivirus engine offers real-time protection to catch threats when they appear, for instance. Your guide to the best antivirus and security software for Mac 2018 for your peace of mind. Intego Mac Internet Security X9 costs £39.99/USD$49.99 for one computer for a year, and there is a free trial available should you wish to try before you buy. Download the latest version of the top software, games, programs and apps in 2018. PROS: High data allowances for free and affordable plans, Good privacy policy with very clear explanation. CONS: Download speeds can be variable, Limited number of locations available on some plans. Best free internet security software for mac.

What I am trying to do is pull data from a different spreadsheet. On my Summary sheet, I pull 8 pieces of data. Sales, Credit Card, Tips, etc.

But each day is on a separate spreadsheet. They are named in the following format 3 03 17 tom.ods. They are not tabs in the same spreadsheet, but completely different spreadsheets. I am going to go back and look at what the responses are, but they do not seem correct. What I want to do is put a date in, have the spreadsheet pull the date out and convert it to the format I need, then pull the data.

Indirect is what I think I need, but I can't seem to get it to access the spreadsheet. I try to avoid using pivot tables. Will use them, but I have found that most of the time, I can't do exactly what I want in them. Can I upload the spreadsheet? Removed spaces and still not having any luck I can manually do the reference: 'file:///C:/Users/Tom/Documents/MarshallTaxiFiles/30317tom.ods'#$Drop_Calculator.$A$3 But, when I try using index, indirect I keep getting ERR:502. Format I am trying is like this: Cell A1 contains 'file:///C:/Users/Tom/Documents/MarshallTaxiFiles/' (Without quotes) Cell b1 contains '30317tom.ods' (Without quotes) This would change for different files Cell c1 contains '#$Drop_Calculator' (Without quotes) This would change for different Cell References Tried using Indirect(a1&b1&c1;a3) and I get ERR:502, but I can't find WHAT is the invalid reference Same thing when I try index.

Mar 15, 2012 - I keep getting a message saying 'A formula in this worksheet contains one or more invalid references', but the message gives me no clue as to. Therefore error like Invalid cell reference errors occurs when formula of spreadsheet consists of erroneous reference of cell. – Invalid Cell Reference Error. If error checking is switched on, press button that displays next showing error, and hit Show Calculation Steps if it emerges.

Tperry wrote:I can manually do the reference: 'file:///C:/Users/Tom/Documents/MarshallTaxiFiles/30317tom.ods'#$Drop_Calculator.$A$3 But, when I try using index, indirect I keep getting ERR:502. Format I am trying is like this: Cell A1 contains 'file:///C:/Users/Tom/Documents/MarshallTaxiFiles/' (Without quotes) Cell b1 contains '30317tom.ods' (Without quotes) This would change for different files Cell c1 contains '#$Drop_Calculator' (Without quotes) This would change for different Cell References Tried using Indirect(a1&b1&c1;a3) and I get ERR:502, but I can't find WHAT is the invalid referenceRead the documentation on INDIRECT, Help → Index → INDIRECT. The first argument is required; the second is optional and only needed if you want to use R1C1 references, which you don't.

Given the contents of those cells use =INDIRECT(''&A1&B1&''&C1&'.A3') to reference 'file:///C:/Users/Tom/Documents/MarshallTaxiFiles/30317tom.ods'#$Drop_Calculator.$A$3 If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.