User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives
Post by Bradley Pogue » Fri Jul 22, 2016 4:04 am
With my business, I have created invoices and a sales summary spreadsheet. Problem is, I wish for certain cell data to transfer from my individually saved invoice spreadsheets to my monthly sales summary. considering the invoices are saved as individual files (w/ ever changing file names), is this possible?
Last edited by MrProgrammer on Wed Oct 28, 2020 7:28 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
Post by Zizi64 » Fri Jul 22, 2016 7:10 am
Linking cell data to another spreadsheetIt is not a good idea to linking (by reference) many spreadsheets to one. (all of the invoices to the summary file)
(This task seems as a database related task, but not a spreadsheet task.)
Otherwise you can create a macro, that can put some data values (without any reference) into the summary .ods file - based on the data of the individual invoice .ods files .
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2 ; AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post by MrProgrammer » Fri Jul 22, 2016 6:07 pm
Hi, and welcome to the forum.Bradley Pogue wrote: I wish for certain cell data to transfer from my individually saved invoice spreadsheets to my monthly sales summary. considering the invoices are saved as individual files (w/ ever changing file names), is this possible?
[Tutorial] External Links In Calc
Some of these techniques do not work reliably unless you save files in the native Open Office format: ODF Spreadsheet. If you're saving in Microsnot Excel format (File.xls), your options may be limited. Spreadsheets with lots of links may open slowly. Calc has to open every one of them (in the background) if you want the data refreshed. Read about that in the tutorial.
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.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.7, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
Post by Bradley Pogue » Sat Jul 23, 2016 2:10 am
I have found base to daunting a task getting forms to appear as my current invoice (too much going on, and I am new to the process of course). I am saving all files as odf, and plan to try macros. Thanks for the help.
Open Office 4.1.2 on Windows 10 4 posts • Page 1 of 1Powered by phpBB® Forum Software © phpBB Limited