suggestion

hello All, I have a list column A is First Name Column B is Last name column C I have C2= CONCATENATE(B2,","," ",A2) Puts it in "Last name, First Name" What im needing done on another sheet is to automatically sort when a name is added/deleted from the list in Alphabetical order based on...

hello yall Im tring to do a DV in VBA code where if A1=Yes then value in D1 must be between 1-120 and if value in A1=No then value in D1 must be between 121 - 150 Im thinking I need a DV in VBA Code. I already have a DV for D1 so I prefer a VBA. Any suggestion is greatly appreciative. Thanks

In column A I have a data which are filled color with white and red. I want to show the cell with white color only in column B. Any suggestion?

Hello everybody, I am experiencing an issue in Excel which I cannot solve by myself. I find myself with 1280 columns with the first two rows (1, 2) filled with data: For printing reason, I need to move all the data under columns A, B and C: Thanks a lot for your help and suggestion! BC

Hi All, I want to disable all type of any error like some OLE/DDE message or any debug error pop up window in excel. Can anybody tell me , if this possible if yes, than What is the code for same. Thanks in advance for your valuable suggestion. Regards, Rajender

Hi Excel Gurus, Once again thanks to this platform that I've been learning alot with my VBA macro skills, helping me a lot to shorten my spending my time on one task. I need the suggestion of one speedometer/gauge chart which I am creating I want to add labels to it for example , 0, 10, 20...

Hi, Good Day Everyone, We need to Download 80 to 90 video & photo. We paste link in excel & from there we want to use Macro store Link:-D:\LocalData\z013304\Kapa If any help or suggestion kindly let me know. Thanks For your suggestion in advanced.

<tbody> 45 62 50 82 112 In a row, there are numbers stretching from Let's say (A1 to A10). I would like the output result to be the number which has reduced. In above example, the result should be 50 because when we go from left to right, 50 is a reduction. From 62 it went down to 50...

I have to insert an introduction in my file excel in order to explain how it is working. The file is a business plan so it is not a user friendly. I want a macro that show a text in order to make like a guide. I want like a key that show an introduction text when you click in it. A text that...

Hey everyone, I'll go straight to the question. I am currently working on a construction schedule for work and I know there has to be a way where I could simply what I am doing so please any suggestion will help. Please look at the attached image. PS I couldn't find the button for upload so I...

Hi I have a shared workbook with a VBA userform that copies information users complete into a worksheet. this works great when the userform is opened only by one person at a time, however if multiple users are in the form the last person to press send gets the resolving conflicts message...

Hello to everybody, I have the following issue. Through 1000 points (X and Y) I did a parabola graphic, now I would like to know if a put a series of points (always X and Y) into graph, if those points are inside or outside the parabola. In case one of them is outside, putting the cell in red...

Im trying to save an Excel file (2010) as a pdf. It contains 5 tabs however it is only picking up 4 of them i have googled the solution and 1 suggestion was that the print quality needs to be the same on all the tabs, which it is but im still getting the error. any other suggestions? Thanks

Hi everyone. I'm thinking what book should i read regarding excel visual basic programming? like which author, i know everyone is good but some are hard to understand. if you have any suggestion kindly help me? :) i'd really like to excel in the world of excel programming. thanks alot!

Hi all, I'm new to the forum. My name is Meagan. I have an issue I'm wondering if someone can help me out with. I work at a non profit organization where navigators help patients with their healthcare and call Medicaid for them, etc. We have an excel spreadsheet where we enter information...

I have been using Excel Visual Basic (VBA) quite a bit with regards to work related stuff (I am by no means a pro or guru, but I get by). Now I have kind of embarked on a bigger project which may require me to enlist the help of some friends too, which are all interested in learning to code. And...

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

I have list of items in 'Sheet1' - Column A. When I type in 'Sheet2' - Column C, I need that Items in 'Sheet1-Column A' should come as suggestions. The user will select a item from that. The user is not allowed to type/select items other than in 'Sheet1'. How to do that?

Hi, I am in a complete mess at this mo, I have alive table, which grows with the time. I am trying to create a dashboard from the table, containing thematic maps, series of dynamic charts and live tables. I am hoping to run over 30 queries and will create 30 odd reports from that data. I...