Recent content by briansandpiper

Skip Many thanks for your time - I will take a look at this! Brian

Skip you are correct - once the data is entered the worksheet is saved to file with a unique filename. I am hoping that the operation of saving the file could trigger a data transfer into the separate workbook that contains the master list to update it by adding the new invoice to the bottom...

Skip The invoices contain unique descriptions of the services we provide. Each invoice text is different and is keyed in by the operator individually. We have found that it is simpler to use Excel as a solution for this rather than Word, or Access and prefer to keep within Excel if at all...

Skip Yes, the invoice is individually created by an operator using a standard template worksheet. The key details from each are then keyed into the master invoice list - this is the operation, i am trying to automate. We need to keep each invoice as a separate file for accounting and...

Skip Yes, that is what i am stiving to achieve - the master list build with each new invoice raised Brian

Skip Each workbook represents a single invoice form with the data in individual cells. the master workbook is simply a list of invoice numbers in rows with key data in cells along each row. Brian

I have a list of invoices on a worksheet and raise individual invoices on separate worksheets. Is it possible to "send" key cell data from the individual worksheets into the correct place in the master list - such information as Invoice number (which is pre-populated in the master list)...

I am trying to setup a worksheet where in a "total" cell I want to apply the results of either of two separate entries. That is to be able to display the value of, say, C12+D12/1000 in Cell F12 OR if both of those cells are blank (or zero value) and cell E12 has a value, then display the value...

Ken Many thanks - that is the solution! Interestingly, though I didn't "import" the previous Outlook .pst file - i simple told the new outlook to use it as the default pst. Will it still have it's limit? Brian

I have been deleting large numbers of emails from my locally held pst file to make sure that I keep it below the 2GB limit. It had crept up to nearly 1.6GB. However, once the delete process was completed, i ahve found that the pst file has apparently not reduced in size. I have closed outlook...

Many thanks - excellent advice as always! Brian

I have recently upgraded to Office 203 and find that when i open a Word file attached to a document it automatically displays in "Reading Layout". Can anyone let me know if it is possible to change this to open in "Print layout"? Thanks Brian

thank you. Problem solved!

Yes, I am and have achieved that, however, i was trying to find out why the 54MS/sec Wireless Networking would only operate at 1MB/sec when the two machines were networked. Brian

Many thanks - will take your advise