to copy data from sales receipt worksheet onto next column of sales summary worksheet


New Member
Feb 22, 2012
:( Hello. I am trying to copy data from a 'sales receipt' worksheet onto the next available column of my 'sales summary' worksheet, then close both while saving the 'sales receipt' worksheet changes into a specified folder ("C:\My Documents\Sales Receipts") as a new file named by the value in I6 (so I have a copy of their receipt), while saving the 'summary worksheet' changes over the top of itself in its present workbook. The data I am trying to save onto the 'summary worksheet' is the item number, quantity, and date of sale.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
The 'sales receipt' worksheet resembles a form where I can enter the item number into Column A (rows 9-22 are available for products they buy), and the quantity bought into column B (also rows 9-22). <o:p></o:p>
The 'sale summary' worksheet has the item numbers in column A from rows 8 through 1586, more may be added later. Column B is a description of the product (using the Index formula) of the item number in column A. My data that Index refers to is on a 3rd worksheet named 'inventory'. Column C of my 'sale summary' worksheet is a total of all the columns added after it (so I know the total sold of each item in that row). This total sold from column C then is plugged into my 'inventory' worksheet so I can subtract it from my total available product to come up with a running inventory. The columns in my 'sales summary' worksheet for successive sale receipts would be from column D on.<o:p></o:p>
I've been working on this crazy thing for 2 months, and have nothing to show for it. I'm way too embarrassed to post my efforts, NOTHING works for me. I know there's probably a relatively short way of coding this, but my last effort resulted was 237 lines long and errors at every sub part (i had 6 sub parts) - nothing worked or was even close. grrrrrr. Can anyone please help me. I know you like having my efforts, but it needs a 'clean reboot' of script! Mine is a total mess. Thank you so so very much in advance, I am at such a total loss here! Thanks.<o:p></o:p>

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...