Macro(s) for extracting data from Rows

[A17BPG]

CAN ANYONE HELP I am trying to produce an order system for Butchers using Excel. I have produced a sheet containing 54 Columns across and 1000 Rows. The Column headings are Cust.No,, Customers Name, Customers Tel No. Turkey, Turkey Size, Price Per. Kilo. These headings are repeated across the page for Chicken, Goose, Duck, Game and other products etc etc all with the Size, Price Per Kilo following each one of these headings. I would like to use a Macro to collect Data from the Rows across Order Sheet ignoring Empty cells. Then place the Data retrieved into a Sheet called “Invoice”. with a layout as follows:

“Cell C1” INVOICE # : [1234] “Cell D1”[INVOICE # ]

“Cell C3” Cust.No. : “Cell D3”[Cust.No]
“Cell C4”Customers Name : “Cell D4”[Customers Name ]

“Cell C6” Item Purchased “Cell F6” Size “Cell H6” Price Per Kilo/Each “Cell K6” Total

The Total Field would be a Result of Size x Price Per Kilo

“Cell J30” Grand Total

Grand Total result from totalling the Total Column.

Within the Macro I would like to generate the Invoice Number and as usual increment by One each time Macro is run, then when each invoice is complete Print It then save it using Customers Name as name of saved file.
If needed and if possible could attach file showing Order Sheet and layout for Invoice.

<tbody>
</tbody>

 

[Leith Ross]

Hello A17BPG,

If you can provide access to the order sheet and layout, it would be faster to write and test the code.

 

[A17BPG]

Hi Leith
Thanks for replying to post, I could email you a copy of the order sheet and the Invoice layout because I do not think I can attach a file to this reply.
Thanks again Brian

 

[Leith Ross]

Hello A17BPG,

Provided you have redacted any sensitive or confidential information in your workbook, you could post on public file sharing site. You would only need to post the URL.

However, I will send you my email via private message, as a backup plan.

 

[Peter_SSs]

We really would prefer the public file-share site - refer #4 of the Forum Rules

Even better is to post small copyable dummy sample data and results directly in your thread. My signature block below has a link with more information about that.