I need to automate a task...
I have a huge spreadsheet that contains item numbers and then the break down of each price for each item #. I need to be able to select a group of cells and save as html (with no header information/tags only table attributes tags).
I literally have over 700 items that each have 3-13 rows of data that I would have to do this for (and redo if there was ever a change in price or anything else). I need a way to automate the task.
I thought possibly a macro, but they are disabled for excel 2008 for mac and I really do not know how to use them. I saw something similar that was solved at:
[login to view URL]
I think I need an applescript.
I do not want to have to open the excel sheet highlight the block of cells, select save as html, then open an html editor (using Dreamweaver) and remove the header tags and body tags and any other tags it decides to put in, and then repeat for the next item number with corresponding block of cells. This would take forever.
I would like a script that I could just run and have it happen. I assume I would need some sort of mark in the excel file so the script would know where each range of cells were and be able to name the html file by the data in one of the cells. Perhaps a cell that gives the range of cells to be used.
I have uploaded a very small piece of the excel file and then an example of the result I need for the first item.
I have alot of experience with Office and Data Entry and I can assure you that I can complete this job for you in 1 day or less with accuracy. I can also provide you with samples of my work. Please send me whatever details I would need to get started and also I can get started on the job immediately.