Search results

Wow .....You made my day..... I will sit and "absorb" your wonderful work and give you my feedback. Do appreciate very much taking the time to pursue a dream of mine.

Here are few: 1. Fun to use 2. Consistency 3. Easy to maintain. 4. Save on testing 5. Avoid reinventing 6. Instead of macro bag full of parts, one for all. Having said that, I am not sure if my idea in clear enough. So, let me try again; Suppose I have some text in a cell. VBA can x-ray...

We all work with range object all the time. I love to have a function that will do the following: 1. the absolute address of the FOUR corners.(Top left,....) 2. the absolute and relative Last Row and Last Column. 3. Number of rows, and number of columns 4. Name of the selection(If any) 5...

worked like a charm, and yes I am using 2013. This is a master piece.... Thank you.

For each multi row column in a range I want to loop each column and remove duplicate, At the same time compress the column by removing the duplicate. Each Column has: HEADER1 Value1 Value2 Value2 Value3 Value1 The cleanup column: HEADER1 Value1 Value2 Value3 The Clean up column...

=INDEX(A1:A5,2) ...returns a reference to cell A2. And, =INDEX({95,96,97,98,99},5) ...returns the value of 99. So, I put 95...99 in A1..A5 And run it, I got 99 in BOTH cases. If reference means "address" of a variable I should get A5 not 99 Can someone "fix" my logic !!!! And...

Thanks you for the tip...I am heading now to PP ..!!!!

A well rounded answer...thanks. If I understood you correctly, you did not "brush" completely the idea that it can be done in excel. Until I get "my house in order; by starting the access route"; can you just help me with this: If I have two tables with "related" data say customer number(key)...

For the sake of ease and avoid building access knowledge from scratch, decided to build my data in related tables in excel. Just to make sure you know what I mean; client master data table(s) each has a customer number to relate these tables, this applies to product tables, orders tables use...

Delighted from your responses you guys. It is my first post and you won me over. My apology for not researching the site before posting. It will not happen again. I will start fine tuning the template, and of course ...I will be back (;

The idea is to input for each room Start/end date and show occupancy period. Then we input a booking request, the workbook will show available rooms for the requested period. To kick start this project, I need a template or a link that will give me an approach to deal with this type of...