advice

  1. E

    copy and paste visible rows

    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...
  2. D

    Copy values of range immediately below same range excel vba

    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...
  3. C

    Putting two macros together

    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!
  4. J

    create a PowerPoint with VBA

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

    Macros

    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...
  6. M

    Advice needed: Power Query vs. Access

    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...
  7. N

    How to protect the workbook from theft.

    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...
  8. P

    Formula Efficiency - Advice please (perhaps useful to many users)

    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...
  9. A

    Round to nearest Quarter

    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,
  10. J

    Finding Duplicates

    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...
  11. T

    Look at column to see if there's an email address...

    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...
  12. Joneye

    Cubic mm Formula Advice

    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)...
  13. A

    Pasting to multiple sheets

    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?
  14. O

    Need advice on how to deal with big texts in cells

    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...
  15. C

    Repetative Code Advice

    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...
  16. M

    scripting.filesystemobject and SharePoint

    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
  17. M

    Find missing days within a Range

    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...
  18. G

    Data Analysis - Related Open Ended Questions with a yes/no response

    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...
  19. D

    if isempty question

    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...
  20. P

    UDFs coding

    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 &...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top