Search results

SirJB7, Your instructions of the naming definitions was excellent and had me in the right direction immediately. After some trial and error for the names of the ranges I have been able to have this working. It is just on home laptop but will run in office tomorrow and give full test. I was...

SirJB7, The constants / declarations is all new to me so have plenty home work. I understand how you have defined the range to the above tables with the cell references where do I insert this data? This is where you lost me For the constants I do understand the names and spaces and yes...

Thought of new issue that the data in labels had "-" in the name which thought could have been error. Took this hyphen out and still the error in code it breaks in first line code Set rngPSCTable1 = Worksheets(gksSheetPSCTable1).Range(gksPSCTable1) Am back into office in morning and...

Ok, have placed the code in and changed for the actual sheet names and fails on 1st line code of build calender. The sheet names I tried to rename to PSC Table 1 and PSC Table 2 and still errors. I believe I have constants and declarations, do you need have spaces or under score separators...

Have updated the "PSC Charts" with dates and label data. Realised that would need 2 rows for "ADD" as they have possible 2 lines on some dates. The "PSC Tables" have many more lines but have put these as examples. I have control page that will enter today date thus on "PSC Charts" Day 1 =...

SirJB7, have uploaded file page to speedy share http://speedy.sh/8Jgje/Test-Workbook.xls This has 2 sheets of table data with 3rd sheet to have report of dates / labels to rows cheers

SirJB7, Can I attach a excel page to this thread as maybe easier to view and not sure if can explain it clear enough Sample file has columns A (label) and C (Date), columns D & E is date column plus 10 days and 20 days respectively. On adjacent work sheet for true value date week 1 with...

my apologies as just joined will read and do more research before asking regards

I am looking to code vba macro to search table with dates in column C (the date format is DD-MMM). this will search and place in row list on another sheet for upcoming inspections for week 1. There will be another row for week 2 and week 3. When sorted for dates this will copy the date in...