So I am still having issues with this. The options that have been suggested so far will not work since I am making this for a friend of mine how is very computer illiterate. I am attaching the workbook with the macro that works and I am also posting the code from said macro.
Here is the code when the button on the first page is clicked:
Here is the code that the previous code runs:
Here is the final goal that I am looking for:
1. To have this workbook and macro work in Excel for mac, I believe it is the 2008 version.
2. The data gets entered into the empty white cells on the "job information" tab.
3. Click the button on the "job information" tab.
4. The macro does the following:
a. Select the "job list" tab
b. Copy row 2
c. Paste Special / values only into row 3
d. Copy row 3
e. Search from the bottom of the tab and paste the data into the next empty row. In other words, have the macro paste the data into the next blank row so that each item just appends to the list.
f. Place the active cell into A1
g. Select the "job information" tab.
h. Clear all of the information in the white cells (not the formulas)
i. place the active cell into C3.
I hope this helps and that someone can help me. This project is kicking my butt and I really need to get it done soon.
Thanks in advance to anyone who is willing to give this a shot. You are amazing!
Bookmarks