excel & vba 2016

Hi I am hoping you guys can help me. I have 2 sheets (SALE) (HOT Items) I want to take things from SALE sheet and have it automatically update on HOT Items sheet. So when ever someone changes something on Sale sheet it automatically updates the HOT Items Sheet. The trick is I don't want every...

I have a sheet with tons of payment data that I need to assign an episode value. There are two columns in which there would be repeating data: Column "MRN" and Column "FDOS". I want to assign a consecutive episode value of 0-5, to each row where the MRN & FDOS are repeating. Example of how it...

I hope everyone is having a good day :-) I was wondering if there was a formula or VBA code that you can recommend or point me in the right direction for looking at data from different tabs and populating them into the master tab. I have summary document and in column B4 - B23 is the tab Name...

Can I please pick your brains on this one as i'm stumped on how I will achieve this. I have been asked to populate a month range between a start date and end date. For example: Column D8 = Start Date Column D9 = End Date Column C25 through to C36 i need to show the months between D8 and D9...

Morning, I have next to zero VBA training, what i have is a previous colleague had created a worksheet with automatic hyperlinking that created a folder structure within a shared drive. We are making a new sheet and i'm trying to use the same code for the new sheet. After spending the past...

Dear All, I need VBA code to extract certain data from multiple text files into a table. I tried to code it myself but couldn't figure out everything by myself so I'm seeking help. There is also a Hexadecimal value in text files that I need to convert to Decimal in the final table. I also need...