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
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...
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
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
Thanks for your quick reply! ! can see where you are coming from but when I look at the connection status icon on both it is giving me "excellent" connection. Both machines are on the same desk and the aerials are no more than 1 metre apart.
I have been doing some more reading up -...
I have recently replaced my home peer-to-peer ethernet network between PC and laptop with wireless cards in PC and laptop, set up in "ad-hoc" configuration. Both cards "see" each other and I seem to have set up the network correctly as I can share internet, share files etc...
I am trying to wireless network my home PC (XP Home) and my laptop (XP Pro) using Linksys cards (PCI and PCMCIA). Individually both cards installed fine and show full speed connection at 54 MB/sec, but when I connect, the speed drops to 1MB/sec. My laptop is also configured to connect to my...
I have been asked if it is possible to create from a currency formatted cell another cell expressing the same value as words - the same way as appears on a cheque. For instance - $236.00 would appear as $two hundred thirty six.00
Does anyone have any suggestions?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.