Recent content by dpw_1

I have created a userform that adds record to a spreadsheet and I am looking for a simple way to autonumber the records. That is, the first record will be assigned a starting number (say 1000) and then each new record would be automatically assigned the next number (1001, 1002 etc.). If...

Hi Narayan, Sorry to bother you on this again but I have one more question on the sample sheet you sent. When I enter there is a blank cell (or if I clear the contents of a cell) in the original table the index formula for the sub table gives a 0 result. Is there a way around this? I have...

Can't thank you enough for the tips. I will try both suggestions. I did figure out how to get the camera tool to be dynamic. So far, the only way to change the number of columns is to do each column individually. Not too bad though. Regarding autofilter, that works too and the button...

Hi Narayan, Yes, I see what you are saying. This will accomplish what I need although it's not as simple as I would have liked. There are some formatting issues that I will have to work around to get the sub-table to look the same as the original data table. I don't mean to take up any more...

Thanks again Narayan, Your solution works fine and I was on a similiar track. The only problem is that the sub-table does not expand dynamically with the original data table. I could add many rows to the sub-table and copy down the formulas (eliminating the #ref errors is easy) but this is...

I have a data table with approximately 40 columns and potentially hundreds of rows. The data contains numbers, text, dates, times etc. I have no need to total any of the rows or columns. Here is a simplified version with only a few columns and rows: Col.A Col.B Col.C Col.D ColE...

Thanks for the invaluable assistance and for taking the time to help out us excel novices. I believe that I now have much more informative and user friendly spreadsheet. Wonderful forum!!

Hi Narayan, Happy New Year and thanks for the help. Unfortunately, I probably didn't do a good job describing my problem so your solution was a little off target. To make tings easier I posted a worksheet with some sample data and two solutions that I tried but can't get to work. Hopefully...

Hi Narayan, Thanks for the reply. I could not access the worksheet you included. The link takes me to my Windows Live shared space but I don' see anything there. Perhaps I am doing something incorrectly? Thanks for the assistance. Don

Hello, I am trying to set up a chart of incidents aboard a cruise ship. Each voyage is tracked separately and can range from 3 days to 15 days. Our personnel enter each incident on a spreadsheet and we have a formula that determines the day of the incident and whether it occurs in the am or...