advice

I am at a loss as to how to get this code to paste special since it is from a calculated field: Any advice? Sub Copy7() Worksheets("2018 PROACTIVE COA").Range("E25").Copy _ Destination:=Worksheets("CAREMORE").Range("C3:C6").PasteSpecial _ Paste:=xlValues End Sub

Hi, I have a spreadsheet of IP addresses 528 rows x 56 Columns (not all rows are full), I need to get a count of the number of duplications. An advice on how I can complete this? Thanks in advance

I am looking for advice on formatting cells for height and width. I have tried selecting the whole worksheet and then using the cell Autofit functions in the format section to no avail. I have multiple columns that are to narrow while others are to wide. Any advice on adjusting these without...

Hi guys, I've been struggling to find a way of searching for the Max in a row of cells and then add another cell's quantity to it. I assumed I'd need a if statement (first) combined with a max statement (second), but there doesn't seem to be much advice out there on this. So far I've tried...

Hi, I am trying to clear the comments from a range of cells without much luck, can anyone offer some advice? c.Offset(, 8).Resize(, 108).ClearComments Regards,

Would like to get the next date from a range with a list of dates =IFERROR(MAX(INDIRECT("'"&D8&"-TVDB'!$C$1:$C$50000"),"<"&TODAY()*"'"&D8&"-TVDB'!$C$1:$C$50000"),"None" Having trouble finding why it's not picking up the next date after today. The return is always "None" Thanks

Good morning, I have searched the forum high and low for a solution and i now need your advice if possible! Is there a VBA code that anyone knows of or a forum piost that i can review to sequence the number like below in VBA to be applied in coloumn B until the end of the data in row A? The...

Hi, My objective is to produce a list of all the numbers of three non-similar digits which do not contain digits 0, 1 & 7. May you please advice. Thanks.

Hi everyone, At a high level, I have to summarize data into a summary. I am given an excel that has the hours an employee has worked as well as how much an employee can charge to clients per hour. This is then multiplied to get to a revenue amount (Est) that we would charge out. The things is...

Hi Forum Hope all is well. I would like some advice on how to resize a UserForm. Is it possible to add the "drag" feature to the bottom right hand corner that makes the form larger or smaller? or is it possible to put the "full screen" square on the top right hand corner? I have searched...

Hi, I am working on simplifying my code to make it easier to follow and check for errors, and I am wondering how often the suffix .Value is needed to determine the value of a cell reference. I would imagine you need the .Value to assign variables (eg x = Cells (r, c).Value) but is it necessary...

Any advice on how to do this?

Hi everyone, I'm trying to make a scheduling template through Excel and was wondering if anyone could provide some advice as to how to go about this. For some context, I am scheduling teams of 3 on 2 shifts per day, everyday. Availabilities for the month are sent in through excel. I was...

Hi, I have this formula, but it is not working. Any advice is welcome! =SUMPRODUCT((database!$B$2:$B$<wbr style="font-family: arial, sans-serif; font-size: 12.800000190734863px;">7=$B$1)*(database!$P$2:$P$7=<wbr style="font-family: arial, sans-serif; font-size...

When i use MONTH () only, the correct value is returned, namely 7 (July). However, when i use it as follows, - TEXT( MONTH(),"mmmm") to get the month name (July), it gives January! Any advice?

Hi, Perhaps this is a straightforward one for you experts here.... I'm trying to find the best way of building a product selection tool for around 3-500 Adhesive Tape products. These are quite technical and have many criteria associated with them. For example: Adhesive Thickness Side 1 & 2...

Hi, I'm hoping someone might be able to help & offer some advice. Please bare with me as i've tried to explain this in detail. Essentially, what i'm trying to do is find a solution to reduce some of our manual admin process' without compromising the existing system too much. My initial...

Hi, Could you please assist with below issue: I send out excel files to various branches within my company. I password protect the worksheets so that formula in certain cells can not be modified. I recently discovered that you can run a macro/vba code to unlock these sheets. How do I prevent...

Hi, I'm trying to find the best way to do the following: I have a spreadsheet where I've downloaded my bank data. The Description column contains things like the card number, Receipt number etc. What I'm hoping to do is take the data in that cell, and copy it into another column. For...

Hello everyone, I hope all of you have been doing great! I've been (slowly) learning VBA recently and realized that it'd be good practice to include error handling in my code. The set up: I'm linking a "profile" workbook to approx 60 other workbooks. As you can see from the below code, the...