tips

Hi, I have a bookmark that pops out for filtering a report. I already had a filter in there for a Relative Date field for Next 2 days, the reason being, this field filters the report for the current day at all times as our client works around the clock. There is a now a requirement by the...

NOTE* Please skip until the next line highlighted in bold if you're not interested in seeing how my setup functions. Thank you! Hello everybody, I am currently managing a minor inventory consisting of 101 unique goods. Currently my excel sheet looks like this: To briefly explain the sheet...

I have assigned a macro to a button on my menu, but I can't find a solution to write and show extended tips. When the mouse arrow is placed over the buttong, only the same name as the buttong is coming up as tip. Have anyone any experience with this...

I have a value in a5 (82700000) Needing it to display in a6 as text 82.7 Million. Could also be 827000000, needs to be displayed as text 8.27 Billion I know it has to do with Len Just cant get there, Any tips or solutions are greatly appreciated. Jack

I have a master worksheet which is generated automatically at the end of the week by our system, which logs tips and mileage collected by each employee. We have deliveries which take place outside of our system which also need to be recorded, but cannot be logged by the system, so they need to...

I've just finished creating my VBA spreadsheet and while it's very useful and 'a bit of a beast' it's not so impressive to look at while running. I played around with turning screenupdating on and off and either way doesn't make much difference so was just wondering if anyone had any tips on...

Hi, I'm AnyaK and as I often mention on my posts on the board for Excel questions/help, I am autistic with multiple specific learning difficulties (ADHD, Dyslexia etc.). I also have visual processing issues, anxiety disorder...well, you get the idea. I was wondering if anyone could relate to...

I'm trying to figure out how to easily sort feet and inches. Let's say I have a column with only feet.. IE: 34' 355' 154' 1503' 14' 6" 10' 7" 50' How could I sort this? I want to go greatest to least, and least to greatest. However, I'm having a hard time figuring this one out.. :( Any...

broad question but i have a report that ends up being close to 26KB and it takes way to long to open and function. most of the report is based off SUMIF statements, stuff like that any resources, tips anyone has i can use/check to try and make more efficient and shrink the size so the user can...

I have pretty much only done one larger build with access. Now im starting to preper to redo everything, build it from scratch and make it a bit better from all the stuff i´ve learned so far. But before i start id like some tips on how to design the tables best. Currently i have quite large...

https://www.youtube.com/watch?v=u3HKXOKzYzA

Have about ~100 tabs here ... This code seems to only work on one sheet at a time. Any tips? Thanks! Sub CopyNameCelltoSpecificSpot() Dim ws As Worksheet Application.ScreenUpdating = False For Each ws In ActiveWorkbook.Worksheets Range("A5").Copy Range("A46") Next End Sub

Hi I’ve used excel a lot throughout undergrad and graduateschool but never knew about VBA until after graduating. I used a lot of powerpivot and VLOOKUPS during an internship. Also, I use excel quite a bit in myengineering position and started taking courses online to learn VBA. My dad hasa...

Hello, I am new to Excel and trying to make a budget planner. I have already created a basic sheet for the entire current month, a second sheet for Payday, and a third sheet for the following month. I have learned a lot of what not to do LOL :laugh:. Any tips or pointers out there to enhance or...

Hello, I am creating a UserForm to collect data in a spreadsheet and I want to add balloon tips to the form that appear when the the mouse pointer is over the field. Similar to how comments work in a worksheet. This is to give the user more info as to what is expected in each field. Is anything...

Have this: A1=val A2=val A3=val A4=val A5=val A6=val A7=val A8=val Need to turn next column into this: B1=A1 B2=A1 B3=A2 B4=A2 B5=A3 B6=A3 Excel won't pick up on the pattern, any tips? Basically need to turn "X" number of cells into twice as many cells, duplicating each cell below itself or...

Hey all Hopefully someone has got a good way of doing this that is somewhat automated or at least 'less' manual. In my company we keep and Issue Log of various issues. For example see below something like what we have. <tbody> ID Raised By Category Issue Details Reviewer Response Status...

Hello, I'd like to add series to a chart on a new sheet. The name and range is based on r, however the range works fine, but the name gives an error. I tried setting the name as a Range variable and as string as well, but no luck so far... Any tips? For r = 1 To 8 .SeriesCollection.NewSeries...

Hi I have assigned the following formatting (+0;-0.0;0) to display all minus values as -0.0 and all positive as +0.0 but my zero calculations are displaying as +0 which is upsetting my conditional formatting. Any tips for formatting type to display all Zero without the + sign in front Thanks Stephen

I'm stumped on some code I'm running. I have two workbooks that are for all intents and purposes identical. I have a macro I am running in both of them that has identical code. In one workbook it takes six seconds, in the other 1 minute and 20 seconds. Does anyone have any general tips or...