suggestions

  1. M

    Opening Existing CSV file and copying the data

    Morning All, I have been working on finding a way to open a csv file within a folder and copy all of the data into a excel spreadsheet but I cant seem to make it work does anyone have any suggestions as to new code I could use? Thanks In advance
  2. O

    Sum Countifs Array with Multiples Criteria

    Hello - I'm having hard time getting this formula to work. I figured out that the formula is not picking up the "C" in the array criteria for column H but not sure how to fix this. Any suggestions? =SUM(COUNTIFS('ABC'!$CH:$CH, "8/1/2017",'ABC'!$H:$H, {"A","B","C"}, 'ABC'!$I:$I, {"D";"E"}...
  3. D

    VBA Code for a print button

    I have setting up a siple print button where on initiation the macro prints a range of cells on a speciic worksheet in a workbook. But I have been getting a compile error. I just cannot see whats wrong...any suggestions? Sub Print_Invoice() Sheets("PreSchoolInvoice").PrintOut...
  4. F

    Range("B" & Rows.Count).End(xlUp).Offset(1)

    Hi Guys, This is probably an easy fix, but I've been struck on this for a while now. Range("B" & Rows.Count) - This will give me the last available row in column B, but I need the paste to start at range("B12"), then B13, B14, B15 etc... Any suggestions? Thank you, FP
  5. M

    Data Validation

    Hi I have a spreadsheet where I need Data validation to pop up a message when something is not right. C7 is "Actual" numbers C8 is "Planned" numbers I need Data Validation in C7 that; Checks that C8 is NOT blank AND Checks that the value in C7 is NOT greater than the value in C8 Any...
  6. U

    VBA sets print margins for 9 pages, but they don't print in the right order

    Hello, I have code to set the print margins on an excel sheet with 9 sheets printed. The code is the following: <code> ActiveSheet.PageSetup.PrintArea = "$A$14:$P$87,$A$88:$P$155,$A$162:$P$221,$Q$14:$AE$87,$Q$88:$AE$155,$Q$162:$AE$221,$AG$14:$AV$87,$AG$88:$AV$155,$AG$162:$AV$221" </code>...
  7. D

    Autofill Sheet

    Every day I get a file from another department like the layout in Sheet 1. I need a way to auto populate Sheet 2 which has the names as headers horizontally instead of vertically. Currently I am doing this manually. I've tried using Index/Match without success so I was maybe looking for...
  8. R

    Overlaid Chart Speedometer needle will not update with value change

    I have a chart "speedometer" I was able to replicate using instructions online but when I change the input value, the chart will not update. I can attach the file if that is easier and possible; the cell I am changing is AA4, but you would notice the needle stays in the same place, does anyone...
  9. R

    Use inputbox to send email note

    Hello, I use email subs routinely to pass WS/WB information around all the time. A request was generated that I add in a function so that users could send me a note about comments or suggestions on how certain WB's are working for the users; kind of like a "contact the webmaster" kind of thing...
  10. S

    Suggestions for Charting

    I have 5 minute data for an entire year related to 5 different tank levels. I have been asked to generate a chart for the level for each 7 day interval of the year. Would this be a good use for a pivot table and then have a chart generated based on the pivot table results? This needs to be...
  11. S

    Building a Product Selection Tool With Excel - Advice Please

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

    Looking For Suggestions (Reformatting/ Transposing Data)

    Hi all, I'm a bit of an excel newbie and am looking for suggestions for any functions/ scripts that will help with my reformatting problem! I currently have a data set with three subheadings. (Number, Name and Fruit.) Currently each row represents a customer with an individual Number and Name...
  13. B

    VBA to create an error log based on IF AND statement

    Hello. I'm hoping you all can help me create a macro that will loop through multiple sheets to identify errors and log those on an ErrorLog worksheet. The excel file is a system generated report with 115 tabs. Column A = Descriptions and Column B = Values. If Column A is blank " " (there...
  14. T

    Suggestions?

    Hello Experts! I have a table that has 8 columns and approximately 84 rows and growing. To the right of the table I have summary information for the entire table. (About 10 rows total) When there is no filter applied, everything is very neat and looks great. When a filter is applied...
  15. T

    Suggestions Wanted - Need to compile data for regression analysis

    I am brainstorming on what would be the best method to compile data, but I keep finding issues with my ideas. I'm hoping some of you have a good solution I can use. Let me describe what I'm doing and looking to do. I have a large workbook that has a summary page, which uses lots of formulas to...
  16. PhilSwEngr

    Does Microsoft have an Excel suggestion web site?

    Does anyone know if Microsoft has a web site where a user can make Excel enhancement suggestions? In particular, I would like to suggest they add a Tootip feature to Worksheet tabs. This could be used to save folks from unnecessarily having to scroll through tabs in a workbook containing many...
  17. J

    cells viewing European manufacturer barcode as formula

    For inventory purposes, cells are viewing European manufacturer barcode as formula. What I need is for the prefixes not to be seen as anything more than just symbols. What suggestions can be posed. Please make me aware if more information is needed to help solve this. Thanks
  18. V

    Excel VBA 2013

    Hi ! I am new to VBA and thought to start with this book "Microsoft Excel 2010 Power Programming With VBA". As I understand there was huge difference between VBA Excel 2003 to Excel 2007. I was wondering with release of 2013, will there be again big change. Or is it a good book to start with...
  19. B

    Code for unable to delete without password

    I have several people saving workbooks into the same folder on our network. I need them to be able to save the workbook into the folder but for them to be unable to delete from the folder. As always thanks for any help.

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