Search results

Hello, Anybody have any ideas of how i can achieve this? Thank you, Best wishes,

Thank you @Nebu, that is exactly what I was trying to achieve. Did you create the pivot tables first and then the VBA?

Sorry about that :)

Hello there, I have been trying to create a unique list of my products, but I have to manually drag my formula down, only then does the new unique client added display in the drop-down. Also, depending on the client I select, the second drop-down list needs to display the correct product...

Hello again, I was having some problems last time. This question is related to my previous question (https://chandoo.org/forum/threads/copy-and-paste-data-based-on-times-and-dates.36061/#post-216175). I need a way to copy and paste booking details into a particular format list. I have provided...

Hello @p45cal Thanks for that. That is the sort of thing I was looking for. Just wondering, how do I get it to display my values on my current list sheet and not start a new sheet everytime I press the button? Thank you and best wishes, ▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

Hello :) Is there a way I could copy and paste booking details into a particular format list? At the moment I'm manually entering the data from the bookings sheet onto the lists sheet in the layout I need. I'm trying to get every instance of the bookings into list form. I have provided an...

Hello, Yes, Thank you. My option 'All' is showing up on multiple rows first and then all my options from the drop-down straight underneath. And for some reason when i select an individual option, the hours don't show from 00:00 - 23:00, but are appearing from 02:00 - 23:00. It misses out...

Is there any other work around this problem? I haven't yet managed to get this to work.

I'm having the issue on the sample file, when I select all, the different availability numbers do not seem to show in the table display space. I'm going to see if I can follow the steps you have taken on my actual file. Is it important to note that the hours and product ids and placed in two...

Thanks for that, but for some reason, my avails are not showing in the tables when I select all. But does show when I select an individual item from the drop-down.

I'm using Excel 2016 and I don't have PowerQuery. I was hoping to use a formula as I have no knowledge of VBA.

Hello, Does anyone know how I can select all my items from a drop-down list and have them displayed along a column with a repetition of the time next to them? So far I have created a drop-down list where I can only select 1 product from the list, I wanted to be able to have an option to select...

Hello :) Just thought I let you know it works now. I don't know what the problem was exactly, but I deleted those product details from my first tab and then inserted a new row with the same details. It seemed to work after that. Best wishes,

Thank you, this works, but im still having the same problem of values for times 9-10 not showing up.

Hello, Iv had a look at my 'hour' field, both on sheet 1 and sheet 2 set to custom hh:mm. Is there anything else I should be checking for? Best,

Oh that's great, Thanks. I'm just wondering because in my actual file I'm having problems displaying some values, for example, for product id 3 i have these 3 dates with times from 6-10, on my actual file it displays the values for 6-8, but does not display the values in 9-10, even though they...

Hello again, Having some issues displaying my values. One sheet has information such as a product id, date of booking, hours booked and its available amount left along with other information. The second sheet is the availability sheet - this is where I compare the product id, date and...

Hello Bosco, I was wondering, in the LOOKUP formula, you look up the value 2 and then the next argument has 1/...etc. What is the significance of looking up 2 and then having 1/? Thank you Best,

Thank you @bosco_yip That is brilliant :D Works great. I would never have thought to use a lookup.

Hello there, I will try and explain my excel problem as best I can. I have a table on one sheet with information such as a product id, date of booking and its status along with other various information. On a second excel sheet, I have an availability sheet - this is where I need to...

Hey @NARAYANK991 Thats exactly what i needed :D Thank you. But how did you do it? best.

Sure no problem. Sheet 1 is where the user enters the desired information, by clicking 'Add' the details are copied to sheet two.

Hello there, I recently started learning excel and am having some troubles, I was hoping someone could help me. I can't fully divulge all the field names and information but to give a simple idea what I essentially have is, A user inputs data into cells on a user form, these cells are then...