important

Hello, I have a work item where I’m in need to mark or categorize the shift data based on times ! Say for eg : 6 AM - 01-30 PM = Morning shift 01.30 PM - 09.30 PM = Noon shift 09.30 PM - 06 AM = Night shift My input data in A column would be 00:57 AM 13:47 PM

Hello Mr. Excel Community Since 5 hours I am struggling with the following code, which I'd love to expand. I simply want to mimic the built in ctrl + F search tool via an Input Box, adding the feature to stay in row/column (ActiveCell) while looking for the name (letters not numbers). Sub...

Dear, I am new in excel and i need a help that which cell i select from the whole sheet that name/number/data automatically should be show on Cell B2. Example i am sharing via image attached, in this image someone has selected Cell N2 and that is showing on Cell P2. Wherever he clicks that...

Hi the code below is working. However if I do not put white space between x and i in line 6 I would get "expect end of statement" error message. Why white space in important here? Thanks a lot. Sub ws_name() Dim x As String Dim i As Integer x = InputBox("enter name") For i = 1...

Hi All, I have a data in a sheet Need to filter column K.. If #N/A then move the filtered data to next sheet. Leave other data in sheet 1. Important thing is that if "#N/A" not found then do nothing. Thanks, Vimal Vikraman.

Hi everyone I am in a bit of a pickle with some data i need to analyse. I have run an employee experience survey and have a spreadsheet with the info. Now i am trying to figure out how to analyse one part and i think i need extra brains! So i have 11 factors that make up our employee...

Hi! I'm having a problem, probably a silly one but it's important for me and i can't figure it out. In my excel sheet i'm putting a countif with the range being a whole column, the problem is that in that same colum is also located the countif formulae. That is causing it to stop counting...

Respected, I have a big file of 400MB+ which has lot of functions. Just 15 days ago I was able to copy a line of 50+functions to another place in just 2-3 seconds but now it takes 2-3 minutes. I have tried every thing like (1)completely writing new formulas so that there might be some routine...

Hello, This might be a very simple question for some of you, but i need help finding the solution. I got a long row that ive filled inn with information. at the end of the row i want it to count it up, im open on suggestions here on how to show it. i was thinking something like this. 5/5 i...

Hi all, I'm trying to build a pivot on data from a survey. The survey is very simple in that respondents were just asked to rate 5 different items on a scale from "not important" to "very important." I want to build a pivot that has a column for each survey item and a row for each of the 5...

Greetings, I'm not sure exactly where to start, but I have an idea of what I'm trying to do. I tried to think of a way to import all these excel files into an Access Database.. but I am not very skilled, I can use the out of the box stuff for Access, but can't seem to get it to do what I'm...

Hello all, i have really quick question. Does anyone pls know, what means "k" in formulas in Excel? And I dont mean function of it, I know what it is and what it does...I would like to know, what word is hidden under the "k" shortcut... :-) I was trying to search everywhere and did not find...

Hi! I have 2 Worksheets and I’d need a Macro that copies data from “Worksheet 1” to “Worksheet 2”. I’ve been trying to get it to work via long formulas, but it seems unclean, glitchy and overly complex. So I thought a Macro would be a better option but I’m afraid I’m not too familiar in VBA and...

Can someone help please? I have a range of cells (B2-E10) which have a number of important dates I require to track. Can I code that when I open the workbook if todays date is less than or equal to the 5 dates leading up to any of the important dates a msgbox will appear? Any help appreciated.

Hello! I have made alot of formulas that gives me some valuable data in months from daily transactions, and i also want these formulsas to summarize in weekly data. Some exemples on some of my formulas is; Result on month...

I am looking to make what I enter in a cell (a date) to a number (a cost). :eeek: For example: 26/07/2016 in one row, I want to make this equal 17.1 in another cell so that I ultimately have a column of dates that will equal numbers, then I want to add them all as a total costing per year...

Hello, In my worksheet I have a column for roles of members - these are defined as "X", "Y", "Z" on my first worksheet ("X1"), although under the roles column in worksheet ("X2") it only lists fields for "Y" and "Z" as they are the more unique roles, and for "X" the fields are just blank. What I...

I created a user form on excel, I had it set to launch automatically with some buttons, that when clicked brings you to different sheets, but when it loads up the screen freezes and only lets you click the user form, except nothing happens! I cant close excel, and I cant access the VBA code to...

Dear All Thanks for this great site, it helped me a lot. I have one problem I need your help or consultation. I have two sheets with two tables 1st sheet: has patients data includes there visit number and visit date and visit operation with his own unique hospital number each...

All i want is to control the format of the data input to a text box, ie; Date = dd/mm/yy, Time = 00:00, Reference = (maximum 6 digits, numbers only), Post code = #### ###. Any ideas why the below keeps bringing up my msgbox? If Me.TextBoxDate.Value <> Format(Date, "DD/MM/YY") Then...