Hello.......Thanks in advance for your help.
Name is Jim.
I have a spreadsheet, at least 500 rows. Data is entered one row at a time, manually. There are 8 columns of data, numbers, dates, descriptions, dollar values. Not all cells in this range will contain data. One column will have the option to qualify to contain a letter "t" as an identifier to that row. Of course not all the rows will have a "t".
When all entries have been made, I would like to create a macro that would add a new worksheet, then copy only the rows that have a "t" entered into the select column. Then sum the last row which has dollar amounts and rename the worksheet to a previous text entry on another sheet in a specific cell.
Been a while since I dabbled in vba but am somewhat familiar. Hope to hear from you soon.
Thanks,
JIM
Name is Jim.
I have a spreadsheet, at least 500 rows. Data is entered one row at a time, manually. There are 8 columns of data, numbers, dates, descriptions, dollar values. Not all cells in this range will contain data. One column will have the option to qualify to contain a letter "t" as an identifier to that row. Of course not all the rows will have a "t".
When all entries have been made, I would like to create a macro that would add a new worksheet, then copy only the rows that have a "t" entered into the select column. Then sum the last row which has dollar amounts and rename the worksheet to a previous text entry on another sheet in a specific cell.
Been a while since I dabbled in vba but am somewhat familiar. Hope to hear from you soon.
Thanks,
JIM