Search results

Yes Sajan, I believe your option may work, I'll tweak it a little bit and show you guys the results. Thanks for the ideas.

Thats fine with me Narayan, My Apologise bobhc if I could go back and change it I would.

HiGuys, Sajan and Narayan really helped me out with my last request however now that my details are getting a bit more complicated i need my excel sheet to do some more work. Below is a link to the updated sample excel. What I would like to do is group the unique plates by time restriction...

Hi All, Yes Narayan, The formula needed to be reworked to show as you said and your understanding below is correct 'My understanding of Nic's requirement is that the application should count the visits ; theoretically a car could have a maximum of 3 visits in the period 9 to 7 ; presence at...

Hi Sajan & Narayan, Yes as suggested you guys are on the right track with each visit being counted individually rather than aggregated. Sajan, As you have shown if your formula complies to the aforementioned criteria which I think it does consider this job solved.

VBA is perfectly acceptable

Hi Narayan, In regards to your questions. 1: Yes you are correct, If the car is not listed in the 11am,1pm,3pm,5pm slot it means it has left. 2: Yes it is true, If the car was to come back at say the 3pm slot it would be considered to be a seperate stay I.e. If the car was recorded at 9am...

Hi Sajan, I thank you for your response. The formula is quite complicated If possible it would be great if someone could impliment it into the sample data and upload it. The reasoning for the no plate was to ensure that the car was counted even though its license plate was missing.

Hi All, It's Nic again, After having such a great experience with my first problem and recieving such great results from the question I figured I'd ask another. I've been racking my brain in order to somehow create a table that can identify how many cars have parked for certain durations from...

Yeah so turns out its because I had the filter one the Description tab to remove any blanks.. I'll turn that off and its fine.. Thanks very much for the help you cannot fathom how much of a help you have been. Pure Genius

Ok so here is the code again, Seems to do the job however when I go back to the summary page it comes up with a prompt "Delete Entire Sheet Row" when I click to swap back to the summary page. If i press no it reinserts and duplicates the entire table if I press yes it does as it should. Is there...

Hi Jeffrey sorry yes I forgot to mention, the tables used in the excel use peoples names as a reference for their table so i replace it with a number quickly on the sample file to cover that. Ill make the changes and see what happens.

We are getting there, Although now for some reason the priority table copies the links and there clickable but there is no text there As you can see i have made a few changes.. Could seem that now its copying the formatting and the links but not the actual text? Heres the code as it stands...

So just replace 'rngDest.Resize(rngSource.Rows.Count).Value = rngSource.Value' with 'rngSource.Copy rngDest'

Hi Jeffrey, Thanks for the prompt reply I've added that exactly into the file however no luck, I may have changed something in the code or misrepresented my changed and thus it hasnt worked. So i've got below a sample file with all the changes made to help you...

Hi Jeffrey, The tab trick is pretty simple they are just text boxes shaped and filled with a colour. Then the current tab is the same except you insert a line up the top to represent the current tab and change the background colour to white. The rest is simply cell fill colouring to give the...

Hi Jeffrey Sorry For the late reply.. Its working great I implimented it today. There is one problem i've found with it. I've modified it a bit to include other things however when the priority or summary table amalgamates all the data it doesnt copy over any hyperlinks that where in the source...

All good Jeffrey I'm quite busy as well so I fully understand

Jeffrey, Do you require any further information from me regarding the issue? if so feel free to let me know. I really do appreciate the help.

Yes I'm only a graduate so at this stage my portfolio includes only minor works. Thanks for your help either way very much appreciated

I know slim to very little about SQL.. Back when I was 16 i dabbled a little bit when I ran a website.. Thats it.. I'm no good at coding but if someone was able to set it up for me I'm sure i could rope learn enough to modify it when needed. i.e. if I add or change a row.. Essentially I will be...

Unfortunately Jeffrey I do not have that add-on installed. As this will be set up at work with the networking and power hungry admins (kidding) getting modifications done to a computer may not be the best option. Ive never set up an SQL server before so unsure on the process for such a thing in...

Hi Jeffrey I've updated my original post to make the information clear to all. I'm using 2007

Here is a link to a sample excel sheet with essentially is the skeleton which will form the greater works. https://www.dropbox.com/s/pln7w05ofs94bfy/Sample%20Sheet.xlsx

Hi All, I'm Nic a Civil Engineer looking at harnessing the mighty power of excel. At current I'm looking to essentially create a Priority Table. In essence this is the background on the excel file. Background: Essentially as part of my works I complete many conceptual designs for works. As...