i have a list i need to copy onto another sheet one by one

I have created an invoice on an excel spreadsheet for a new business and my 
plan was to use a sales  list on another sheet linked to the invoice , using 
the same fields it worked perfectly the first time using basic = sign, then i 
discovered that second and subsequent entries to the list would have to be  
set up again . can excel handle this so that I don,t need to retype after 
each entry.
0
Utf
3/25/2010 9:58:01 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
446 Views

Similar Articles

[PageSpeed] 14

      If desired, send your file to my address below. I will only look if:
      1. You send a copy of this message on an inserted sheet
      2. You give me the newsgroup and the subject line
      3. You send a clear explanation of what you want
      4. You send before/after examples and expected results.


-- 
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett@gmail.com
"bigsister" <bigsister@discussions.microsoft.com> wrote in message 
news:779C5ADB-369C-40C3-A07A-64925893F0F3@microsoft.com...
>I have created an invoice on an excel spreadsheet for a new business and my
> plan was to use a sales  list on another sheet linked to the invoice , 
> using
> the same fields it worked perfectly the first time using basic = sign, 
> then i
> discovered that second and subsequent entries to the list would have to be
> set up again . can excel handle this so that I don,t need to retype after
> each entry. 

0
Don
3/25/2010 10:00:20 PM
On Mar 25, 2:58=A0pm, bigsister <bigsis...@discussions.microsoft.com>
wrote:
> I have created an invoice on an excel spreadsheet for a new business and =
my
> plan was to use a sales =A0list on another sheet linked to the invoice , =
using
> the same fields it worked perfectly the first time using basic =3D sign, =
then i
> discovered that second and subsequent entries to the list would have to b=
e =A0
> set up again . can excel handle this so that I don,t need to retype after
> each entry.

You can, but need to be more specific of what you're looking for.

My guess is that you have a sales info entered on one worksheet and
want another sheet that generates the invoices for the particular
sales.
If I'm right, a quick suggestion would be to use a MS Access database
for this, rather than excel.  You can set it up similarily and then
have invoices print for all entries that are not marked paid in full.
If you need help email me.....unemployment is boring!
0
Reeza
3/25/2010 10:55:23 PM
Reply:

Similar Artilces:

Better to "nest" or use multi-level list?
I'm in the process of creating/defining a style(s) for a list that will be numbered in "level 1" and have indented bullets in "level 2." For such a list is it better to define a multi-level list style and linked paragraph styles? Or use one's already defined numbered list and use one of the Word's pre-defined bullet lists when needed for the second level? As part of this question, is is preferable not to have a style "nested" within another style or doesn't it matter? Thank you. -- Norm Hi Norm: I'm not sure why yo...

Drag and drop on a recycle bin ... a little help needed
Hello all I have implemented the drag and drop code from The Code project http://www.codeproject.com/shell/explorerdragdrop.asp?msg=420048 but it crashes when the files are dropped on the recycle bin. CCmdTarget::~CCmdTarget() { #ifndef _AFX_NO_OLE_SUPPORT if (m_xDispatch.m_vtbl != 0) ((COleDispatchImpl*)&m_xDispatch)->Disconnect(); ASSERT(m_dwRef <= 1); <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< HERE #endif #ifdef _AFXDLL m_pModuleState = NULL; #endif } Does anyone have an...

how to prevent blank cell copied when combining cells?
I've tried to combine data from few cells using "CONCATENATE" function. But, when a cell is blank, a blank appears in the result. How to prevent this blank? please give sample to understand better "Vicneswari Murugan" wrote: > I've tried to combine data from few cells using "CONCATENATE" function. But, > when a cell is blank, a blank appears in the result. How to prevent this > blank? =if(a1="","",a1&" ")&if(b1="","",b1&" ")&c1 It kind of sounds like you were separ...

Customizing Activities\History LIst
Is there a way to add a date to Activities' History list? It would be nice to know when each activity happened. Thanks, Troy Troy, no way currently, although Microsoft has mentioned it might be an option in version 2.0 (nothing is guaranteed!) A few ISVs have custom products that do it... www.salentica.com www.c360.com Dave "Troy" <anonymous@discussions.microsoft.com> wrote in message news:af6b01c436bd$ce671f00$a001280a@phx.gbl... > Is there a way to add a date to Activities' History > list? It would be nice to know when each activity > happened. >...

Distribution List Changes
Hi All, I have a mail enabled distribution list with four users. Only those users plus the Administrator have rights on this group. Yet a seperate user is able to add / edit or remove users to this group even though they do not belong to this group. The user does not even have admin rights and is able to make changes. Let me know of any options I can try. Thanks Waynear wrote: > Hi All, > > I have a mail enabled distribution list with four users. Only those > users plus the Administrator have rights on this group. > > Yet a seperate user is able to add / edit or remov...

Need to decrease decimal places for an active currency ID
We currently have the JPY (Japanese YEN) set at 2 decimal places, but it needs to be set to none. We already have transactions against this currency is several databases (we have over 120 companies in MSD GP 10), so rebuilding is not a good option. Is there any way to force the reduction of decimal places (I'm assuming update MC40200 set DECPLCUR = '0' where CURNCYID = 'JPY'), and what would the consequences be? Thanks! The only way to do this is via SQL, then to perform a checklinks on all Multicurrency table. However, not because you can means you sh...

Drop Down List and Check Box
Hi...I was search for this topic but don`t found the solve...Anyway I have a drop down list like this [image: http://www.geocities.com/augurtrade/excel_checkbox.txt] and this [image: http://www.geocities.com/augurtrade/excel_checkbox2.txt] ok my questions is what is (Blanks) and (NonBlanks)...? Is it possible for me to see only all the check box that was checked or vice versa...??? How to make a total below the checkbox i mean when someone check the check box, a total number appear below the last check box [image: http://www.geocities.com/augurtrade/excel_checkbox3.txt] [image: http://www.g...

Is there a way to copy text from a published knowledgebase article?
Hello, This is a question I haven't been able to find an answer to. Our helpdesk quite often needs to pass on instructions from the knowledgebase to our people in the field. However, once a knowledgebase article has been published, copying of text from it is disabled. Is there a way to enable that feature? Sorry, if this is a basic question, but I've googled this quite extensively and I've searched through the manuals without any results. Thank you for any replies. Pete ------=_NextPart_0001_00C5BA0B Content-Type: text/plain Content-Transfer-Encoding: 7bit Hi Pete~ I am a...

Control Button help needed
In the microsoft template database "Classroom"/ Classes form there is a command button that will open another form (Students) on a specific record in the subform. I can't figure out how to do this. Can anyone out there help me? The code behind the button is using the OpenForm method and is passing the ID of the record to open to as part of the "WHERE" argument. Look up OpenForm method (or action to see the macro version) and review the arguments. "Obeide115654" <Obeide115654@discussions.microsoft.com> wrote in message news:325A53B7-7553-40F0...

Centre align if less than one line of text
I have set up my normal style to be justified, however if there is less than one complete line of text (no wrapping) I would like that paragraph to be centre aligned. Is this possible without having to do it manually each time? I imagine I am using Word for Mac 2008. many thanks for any help in advance. -- daved2424 No, you can't define a single style to work in different ways. Assuming you are talking about an actual 1 line paragraph rather than the last line of a multi-line paragraph you'd need to have a different Style or change the alignment directly. If ...

Auto response more than one time
Is there a way to set a rule in Outlook, using OutlookXP, that will send an auto response for each email received. It only sends out the auto response once per email address of the sender. Need it to go out for every email received. That is set at the Exchange Server and you will have a tough time getting the admin to change it since it causes loops of never ending Out of Office notifications. "Robert" <rsitarzewski@ci.bellevue.wa.us> wrote in message news:11bf01c3520a$0b698080$a001280a@phx.gbl... > Is there a way to set a rule in Outlook, using OutlookXP, > that wil...

Copy ADO Recordset
I have a subset of records I want to "clone" into the same table. Originally, I did it with SQL, and that worked fine, but I've had to change some of the fields and the SQL is becoming confusing for anyone else who follows to understand, so I'm doing it with a pair of ADO recordsets... Initially, what I want to do is copy EVERY field from each record in the one recordset (rst2) into the new record in the other recordset (rst1). Ideally, I should be able to code something like while not rst2.eof rst1.addnew rst1.everyfield=rst2.everyfield ...

SMTP won't work, but OWA does for one user
I have a user whose mailbox exceeded the storage limits and Exchange "Closed" the account. They can log into the account via OWA, but when they try to login via Outlook over SMTP, it keeps prompting for username & password, and displays the following error: "There was a problem logging onto your mail server. Your Password was rejected. '-ERR Logon failure: unknown user name or bad password.', Port: 110, Secure(SSL): No, Server Error: 0x800CCC90, Error Number: 0x800CCC92" I tried to go into Active Directory to reenable the account, deleted mail from the ac...

Sound shows on custom Annimation list yet no sound heard
When the PP Presentation is saved as a show,some slides have sound and some do not. All sound came from the same folder. Also, when playing the slides while in PPPresentation, swome have sound and some do not despite all being indicated on custom annimation lisy and all startin "after previous." Thanks! Often when one sound plays but another doesn't, it's an issue of the length of the file path. What's the file path to your music? Is it really long? If so, the longer-named songs might just be hitting the length limit. -- Echo [MS PPT MVP] http://www.ec...

how reliable is the "Who has you in their contact list" list?
Because someone who I think has recently (within the last week) deleted me is still on this list (I don't think she blocked me), but when I check who deleted me on blockstatus.com, he shows up. could it be it's not updated? which of the two would be more reliable? -- maykk Greetings, Do not use these websites, they will steal your identity and sell it. You should change your password immediately. That said, in general, the "who has..." list within Messenger is accurate. There have been instances over the last six-months or so where the list (and m...

Selecting from contacts list
I have all my contacts in the Contacts List and I want to delete all those with a common extension i.e. all those who have email addresses @hotmail. I am using Outlook 2007 Can you do a search or advanced search which will show the contact you want to delete? You should be able to highlight & delete them from the results. "GrahamC" <GrahamC@discussions.microsoft.com> wrote in message news:6AC1880D-9632-4ED9-BAE2-7083690B9FA7@microsoft.com... > I have all my contacts in the Contacts List and I want to delete all those > with a common extension i.e. all t...

Microsoft CRM needs the cookies to use the web client
When it loads the Microsoft CRM tool bar on the Web Client I receive the following message: At moment, your web browse is configured to disable cookies. Microsoft CRM needs the cookies to use the Web Client. What should I do? Thanks! "wanny" <wanny@discussions.microsoft.com> wrote in message news:C98DBCF0-096E-4DC3-A409-FC4A26E89E9C@microsoft.com... > When it loads the Microsoft CRM tool bar on the Web Client I receive the > following message: > > At moment, your web browse is configured to disable cookies. Microsoft CRM > needs the cookies to use the We...

Script to list access right
Hi I am trying to find any script which would generate list of login users with certain access level (select, write etc.) at one particular database. Is there something like that? Thanks. Justin ...

a list of lists
currently i use CArray to keep track of a list of objects, but I don't know MFC classes well enough to keep track of a list of lists. I'd appreciate some suggestions "wanwan" <ericwan78@yahoo.com> ha scritto nel messaggio news:1187535523.924671.143350@j4g2000prf.googlegroups.com... > currently i use CArray to keep track of a list of objects, but I don't > know MFC classes well enough to keep track of a list of lists. I'd > appreciate some suggestions You might want to embedd your list based on CArray into a class (e.g. CListOfSomething), and then ...

Smart List export to Excel #2
Hi, We are using Dynamics 9.0 and Office 2003. When we try to do a Smart List export to Excel, we keep getting an "Exception_Class_Object_Exception" that references varying object errors, such as 'Cells' or 'Value'; the object errors will change each time we try an export. As a workaround, I've found that closing Excel before doing the export allows the export to complete successfully. However, that solution isn't acceptable, as our Dynamics users would like to be able to work in Excel, doing other tasks, while the export is processing. Does anyone...

List of different values in data area
Hi excel specialists, How Can I automatically get the list of different values from the dat area and to find out their frequence? INDIVIDUALLY MEASURED VALUES: 3,5 4 3,5 4 3 3,5 4 4 3 3,5 4 3 3,5 3 3 3,5 4 4 Thanks for your help in advance. Balcovja -- balcovj ----------------------------------------------------------------------- balcovja's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2623 View this thread: http://www.excelforum.com/showthread.php?threadid=39572 Take a look at FREQUENCY in Hep -- HTH RP (remove nothere from the email address if m...

range specified by the value in another cell
I have the following problem: I have let say 100 numbers in column A, and a number n<100 in cell B1. I want to have the sum of the first n numbers in column A, so I would need to specifiy the range A1:An, but I need this independently of the actual value of n. I have tried A1:A(B1) with but it doesn't work. So has somebody any idea -- Message posted from http://www.ExcelForum.com Hi 2 ways for it 1. Use the formula =SUM(INDIRECT("A1:A"&B1)) 2. Create a named range RangeToSum=OFFSET(SheetName$A$1,,,SheetName!$B$1,1) The formula will be =SUM(RangeToSum) -- (When s...

Can data in one text box automatically appear in another?
I am trying to design a form in Publisher, and would like to link text boxes so that data entered in one will automatically appear in another on the same page. Is this feasible? How will this form be used? "G.O.G." <G.O.G.@discussions.microsoft.com> wrote in message = news:E4C951DF-7D4F-4FC1-8F6B-2C0B4EB8882A@microsoft.com... > I am trying to design a form in Publisher, and would like to link text = boxes=20 > so that data entered in one will automatically appear in another on = the same=20 > page. Is this feasible? Maybe with some programming... -- Mary Saue...

Global Address List and Handhelds
We use Ipaqs throughout the company, and I was wondering if there is anyway to have exchange add the GAL to the outlook contacts on the workstation, so that when they sync up, they will retrieve the Global Address List? In news:%23TkYtT0$GHA.3560@TK2MSFTNGP04.phx.gbl, Flip <phil.atkinson@beltek.com> typed: > We use Ipaqs throughout the company, and I was wondering if there is > anyway to have exchange add the GAL to the outlook contacts on the > workstation, so that when they sync up, they will retrieve the Global > Address List? No (and this wouldn't really be an ...

Fields in items list-- add/delete
Hai, I am using RMS version 1.2. In Stores Operations Manager it displays list of items when click on Database-->Items. It displays only five columns. Now i need to add / delete some fields in this list. Is it possible to add or delete the fields? if yes how can i add the fields? Thanks in advance, Nagendra On Wed, 27 Apr 2005 01:22:02 -0700, "Nagendra" <Nagendra@discussions.microsoft.com> wrote: >Is it possible to add or delete the fields? if yes how can i add the fields? I don't think so antonio ...