Where to start? Planning stage

[sinned141]

Hi All

In my efforts to learn about VBA (which has been going on a while and has mainly involved trawling this site for answers)
I started helping my friend with way to make building quotes easier. I managed to create a workbook which is pretty basic and I feel I could do more, when I say "I" I mean I think that it is probably possible to do more.

Well several months later and I am no further than I was before, I think the problem is in my planning, I have several ideas that seem good but I have no particular order in the way I am tackling this.

Does anyone have any views on the best way to go about panning the project?

 

[BrianMH]

I wouldn't do part in access and part in excel I'd just do it all in one application. If you are not familiar with access and the way databases should be set up I'd go ahead and start familiarizing yourself with it. You will find projects where you are adding, removing and editing large amounts of data much easier.

What you are looking to do can certainly be done in Excel so go ahead and continue on that path for now. You can in the future, once you have further knowledge, port it over to access if you wish.

 

[sinned141]

Thanks Brian

I think I will stick with excel for now just until I am more confident with that and VBA, I'll have a look at access again when I get chance.

I inherited several Books with the laptop they are mostly for 2007, I am now using 2013, should I be looking at purchasing new books or will they be sufficient for most of my needs? admittedly I tend to be lazy and search this forum for immediate solutions and just browse the books when I am doing nothing else

 

[BrianMH]

I wouldn't invest in new books. You should be able to get a good deal of knowledge from what you have and then if anything bugs out you can always search.

 

[sinned141]

thanks once again

 

[sinned141]

Could I be a nuisance and ask someone to check if the answer I gave here was the easiest way to solve this
http://www.mrexcel.com/forum/excel-...nst-set-hours-per-fortnight-shown-1-cell.html

I just want to check if I have given good advice

Thanks