Search results

Hi Howard, Thanks for the speedy reply. My button will be a seethrough box overlayed on the cells where I need this macro to operate. So really they will never actually select a cell, which is why we are stuck. Im fairly sure this is possible as I saw it on a worksheet once but didnt...

Hello all, Im working with a friend to try and create a generic macro to assign to a button that, when clicked, will move down one cell (from where the button is clicked) and insert a row, simple enough. The problem we are having is that I dont know how to get the macro to know where it is...

@Bobhc, Thankyou very much for the alternative. I'm actually working on another workbook where im using the methods you have mentioned. And I'd recommend a bottle of Laphroaig ;) Regards, Gumbles

Ah solved it! If you make the list a table it automatically updates the range for you.

Hi there, I have looked throught Chandoo's website and found several functions (OFFSET or INDEX) that could apply to this but I can't seem to get it to work. I have a list in say B7:B9 and Im using COUNTA to count if anything is put in those cells. The problem is I want the COUNTA function...

Worked like a charm Sir JB7, Thankyou Very much. Gumbles

Im looking for different approaches and will look at creating a user form. I think it was abit ambitious as well as ambiguos! Thankyou for you help. Gumles

Hi Jason, Thats not exactly what im after, When you fill a table and press enter and start entering data it formats that new line as a table. What I am trying to get is if you fill the table it automatically inserts a row at the bottom and formats it as a table. not just add a row at the...

Hi Narayan, Yes, I realise its a rather odd request, hope i can make it clear. Your assumption is partly correct but when you complete the data entry in the first section (G7:Z9) it makes one more line available so now G8:Z10 is visible but G7:Z10 is scrollable (but only 3 lines are visible...

Hello all, As I understand it when you format cells as a table,if you put data in the row below it will automatically add it to and format it as a table. Is it possible that aswell as formatting as a table it can insert a row into the worksheet? This is because I have data in the cells...

Ha brilliant! to be honest what my colleagues are asking me to do should really be done in access but what can you do... I would agree that having a raw_data page and ouput_page would be the ideal approach and is how I normally operate my projects but ive been asked for this kind of input...

Hi Faseeh, So A7:K10 will show 3 lines of the list/table and the headings are fixed above, (not sure if a table is more beneficial) but when you want to add to the list, you scroll to the bottom and enter information into the new row. But you can only ever see 3 lines of the list at a time and...

Hi there, apologies if this is the incorrect topic but I couldnt see any better matches. I am trying to create a section in excel (lets say A7:K10 with headings on the row above) that is scrollable (up to say 100 lines) and the information is entered directly into this scrollable section. The...

Hi Narayan, Im not sure if I am being silly here, but I cant see any of the code you have written? Do you know why this might be? And it looks great by the way. Gumbles

Hi Narayan, Im afraid the company firewall doesnt allow me access but I will check it this evening and report back either this evening or tomorrow. Thanks again for your time. Gumbles.

@ Narayan, Thankyou, I can wait no problem. @ Ahsan, Thanksyou, but I think you may have misinterpreted my problem, as I need the information to be copied FROM weekly report TO booking code so the formulas would need to be in the booking code cells not in weekly report worksheet. The...

Hi Narayan, Do you think you could give me a code example then? Being an excel Ninja, im sure your code would be alot neater then mine lol. Gumbles

@Hui, Thanks very much for the SUMPRODUCT suggestion, Im looking at the link right now, but I need the hours from the weekly report to be logged in the booking code, as information is put into the weekly report and the booking code log should be automaticly copied. Because of this im unsure...

This is a plain version of what i have. https://www.dropbox.com/s/61cns2cwbmzcmej/Mock%20Weekly%20report%20with%20Booking%20codes.xlsx Hope it makes things clearer. Gumbles.

Will try and get a sample to you guys this evening but might be tomorrow evening. Ideally i was trying to use formula and not macros as I am only working here for another 6 months and other team members are very uncomfortable with macros. I was wondering if it would be possible with multiple...

Hi there, I am struggling to find the best structure for a formula that must meet several conitions before taking the value from one worksheet and putting it in another. Due to IT security at work im unable to upload any samples so will do my best to explain my situation. I am taking the...

Well that makes perfect sense! in that case i shall use that technique. On the off chance, do you know if this is the technique used by chandoo in his lastest project portfolio, as i think his is very proffesional approcach? Regards Gumbles.

Hi there, I have a team project file that contains one small macro. My team is not all excel savvy so i would like to put a warning message that forces them to enable macros before they continue. I have tried to replicate the one chandoo has on his project portfolio but my VBA isnt as awesome...

Dont worry, sorted it. Thankyou very much Debraj.

Hi Debraj, I now have the file, but when I enter a date into column "C" nothing happens... Is there something I must enable or press to initiate the process? Regards, Gumbles