suggestions

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

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"}...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.