advice

Hi can someone help with the following code? I want to filter the "HR Advice & admin" sheets to display all rows which have no data in collumn ("N") then paste all rows displayed into "Sheet1". I want to exclude the top row to be copied and pasted into the second row on "Sheet1". What I have...

In my worksheet I have continuous rows with data in D7:D726. I column E I have data from E7:E24. I need to copy the data in range E7:E24 and autofill the remaining rows in col E (i.e. E25:E726) with that range of values. The ranges in both col D and the initial range to be copied in col E...

So i have a macro that merges a file and makes it into a pdf. I have another macro I am trying to put into the first macro that deletes rows when they aren't filled. I cannot figure out how to put the macros together and get it to work. Ant advice is appreciated thank you!

hi, how to create a powerpoint document wit vba any link, any advice. thanks

Hello, We created a macro to send out personalized emails to our customers with each individual email having an attachment of that certain customers invoice. When running the macro I seem to keep getting stuck where it says : MyAttachments.Add(attachment). Not sure if there is some way to...

Hello, and thank you in advance for providing input or advice if you can. I have a set of data that is almost 800,000 rows with multiple columns. I initially have to split the larger file up into smaller files to get it into ArcMap so I can spatially join the records and export it back to...

Hi Friends Thanks to all of you for always helping me. Here, I need an advice from you. I have an excel workbook which has multiple sheets linked to each other with formulas and macros. I want to share this workbook with my team for their use when they are on duty, but I want to secure this...

Hello all, Please can anyone offer advice at to whether this is a good or bad habit. I have a number of workbooks that pass data between themselves. Rather than have links embedded within the myriad of different worksheets I have created a single sheet of "IMPORTED" values which the formulas...

Hello, Please advice, how to round a fraction to nearest quarter, for example: <tbody> Value Result 1.1 1.00 1.2 1.25 1.3 1.25 1.4 1.50 1.8 1.75 </tbody> Thanks in advance,

Not an advanced Excel user at all, but trying to figure some things out. Was hoping to get some advice on my situation and hopefully come up with a solution. I have a Column that holds phone numbers in the their traditional format, (123) 456-7890 and receive a CSV report of these phone...

I have hundreds of rows of data in one column (Column A) that has either a name or an email address. I want to find a function that says IF there's an email address, do a vlookup to get the persons name (found on another table), otherwise don't do anything and just show me the name that's...

I've to calculate total cubic volume of a product packaging. 1) Below are all mm 2) formula used is SUM(L*W*H) 3) Question, i've never done this before so seeking advice im correct or advise me what forumla and method is better? 4) Using Mac Excel 2016 (sorry unable to paste in properly)...

Evening all! This may be a far stretch.... I have workbook with 500 tabs. I have made the first tab exactly as it needs to be but now I want to copy that (formulas and all) to the other 499 tabs. Any advice?

Hey, everyone, I just joined a company a couple of weeks ago and I realized that the department I'm working on has a lot of room for improvement. I don't want to get into details, but we deal with risk management. As we can imagine, we have excel files with hundreds of risks and KRIs that were...

Hi all, I've been using Excel for decades but I've only just started using VBA. I currently have a task that entails copying 600 cells from several sheets in one workbook to a table in another. And then repeating the process on 300 other workbooks The code is quite simple Sheets("Section...

I have a process that needs to loop through all the files in a SharePoint folder but the scripting.filesystemobject function doesn't work. I'm really struggling to find a solution to this and hopefully someone can give a bit of advice. TIA

Hi guys! I would need to know if some days are missing, see the example below please. I have a range of days like this : 01JAN19 - 20JAN19 24JAN19 - 30JAN19 I'd like to get an output of the missing days: 21JAN19 22JAN19 23JAN19 31JAN19 Do you have any advice on how to build it? Thank you...

Hi, I've searched multiple different queries with google about how to accomplish this with excel but have had no luck. I have a question on a survey which reads: Q1. What advice was given during call? I plan on grouping the responses into themes/categories which I have found out how to...

Ok, so I am relatively new to vba and i need to show a userform if a cell is empty, but for some reason it is not running correctly. Could i get some help or advice on how to better handle please.:) Sub Auto_Open() Worksheets("Report Disposition").Activate If IsEmpty("D3:J3") Then...

Hi Mrexcel. I have several customised algorithms (>27) that relate with each other while others are stand-alone. My headache & heartache is how to code them as a Desktop App (as UDFs) because I need to use them nearly every 15 minutes. I would only need to import my variables to the App &...