iaindowner
New Member
- Joined
- Aug 12, 2014
- Messages
- 18
I have a workbook which acts as a till system. What I need to be able to do is every time I press a button which says confirm payment I need to export the transaction to a Comma Seperated Value file. The information which I need to export is contained within specific ranges in every transaction and needs to be exported into the CSV in the following format:
Till Number, Server Name, Product Name, Quantity, Total Price, Current Date, Current Time
The transaction is contained for example in range A1:C5, column B being the product name, B the quantity and C being a vlookup formula which shows the product price.
E.g the transaction looks like this:
<tbody>
</tbody>
I want to export the info to look like this:
Till 1, Jack, Product 1, 3, £3.00, 9/9/14, 22:32
Till 1, Jack, Product 2, 5, £2.00, 9/9/14, 22:32
Till 1, Jack, Product 4, 1, £6.00, 9/9/14, 22:32
Till 1, Jack, Product 2, 1, £0.40, 9/9/14, 22:32
All the other information is contained within other ranges e.g Till number in D1, Server Name in E1 etc.
There will be multiple transactions so each file must save with a different filename i.e. Transaction#1, Transaction#2 etc.
Anyone's help will be greatly appreciated.
Till Number, Server Name, Product Name, Quantity, Total Price, Current Date, Current Time
The transaction is contained for example in range A1:C5, column B being the product name, B the quantity and C being a vlookup formula which shows the product price.
E.g the transaction looks like this:
Product 1 | 3 | £3.00 |
Product 2 | 5 | £2.00 |
Product 4 | 1 | £6.00 |
Product 2 | 1 | £0.40 |
<tbody>
</tbody>
I want to export the info to look like this:
Till 1, Jack, Product 1, 3, £3.00, 9/9/14, 22:32
Till 1, Jack, Product 2, 5, £2.00, 9/9/14, 22:32
Till 1, Jack, Product 4, 1, £6.00, 9/9/14, 22:32
Till 1, Jack, Product 2, 1, £0.40, 9/9/14, 22:32
All the other information is contained within other ranges e.g Till number in D1, Server Name in E1 etc.
There will be multiple transactions so each file must save with a different filename i.e. Transaction#1, Transaction#2 etc.
Anyone's help will be greatly appreciated.