Hi there, i have a daily report which involves tables, items purchased and a name of whoever was in charge of that table.
I need to export into a simple text list, however i'm not experienced with macros at all..
I've attached a sample excel and also the desirable text that i would need.
Do let me know if anyone needs more details to understand the project.
Basically:
Date
Name1:
Table number
Products
table number
Products
... and so on relevant to Name1
..
Continuing on with all 4 names.
Last edited by johnstamosiscool; 01-16-2018 at 11:28 AM.
So based on your example you want a date in cell B1, which you didn't explain why that date, two blank lines and then four names from the tables?
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
The date is just an example.
Please Ignore Cells H4-H7
all the data in the excel would be input manually.
Every table has a list of products.
Every table has a name in the top right cell.
Every table has a table number in the top left cell.
The text export would be
Date (pulled from cell H1)
Name 1:
Table 1
Products
products
Table 2
products
products.
basically each name has a list of tables with the products in it.
hope this clarifies
bump please if anyone can help.
Originally Posted by johnstamosiscool
Is anyone able to help me with this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks