jamieleeuk
Board Regular
- Joined
- Feb 9, 2009
- Messages
- 99
I'll try to explain the best I can. Please let me know if you're not clear on what I want.
In column A, I have listed numbers (1 to 10) which on my sheet is Row 4 to Row 13. This list is headed "Call ID".
Columns B, C, D, E, F, G, H, J & K will have data which is imported from a userform. This information is constant, ie - textbox 1 on userform will always put into same columns and will put the data into the next available empty row.
Column I contains a concatenate formula to concatenate the data in columns F, G & H (which is Day/Month/Year)
B,C,D,E,F,G,H,I,J,K = Surname, Forname, Team, Office, Day, Month, Year, Start Date, Reported By, Date Stamp
Columns "Day, Month & Year" are hidden
In range M:4, I am going to have a cell with Data Validation which will allow data ONLY from a specified range, this range being the Call IDs (A4:A13).
I then want to press a button which looks at what call ID I have selected and delete the data for that row. I then want any subsequent rows of data to move up one row.
Is this possible?
In column A, I have listed numbers (1 to 10) which on my sheet is Row 4 to Row 13. This list is headed "Call ID".
Columns B, C, D, E, F, G, H, J & K will have data which is imported from a userform. This information is constant, ie - textbox 1 on userform will always put into same columns and will put the data into the next available empty row.
Column I contains a concatenate formula to concatenate the data in columns F, G & H (which is Day/Month/Year)
B,C,D,E,F,G,H,I,J,K = Surname, Forname, Team, Office, Day, Month, Year, Start Date, Reported By, Date Stamp
Columns "Day, Month & Year" are hidden
In range M:4, I am going to have a cell with Data Validation which will allow data ONLY from a specified range, this range being the Call IDs (A4:A13).
I then want to press a button which looks at what call ID I have selected and delete the data for that row. I then want any subsequent rows of data to move up one row.
Is this possible?