identify

Is there a way with VBA that I can identify if a row will split over 2 pages once populated?

Hello all, I am trying to identify if the last character of the bin location is upper or lower case. I would like to see the answer in column C. Can anyone shed some light on how to do this? Any help would be greatly appreciated <tbody> A B C 1 ITEM BIN LOCATION UPPER/LOWER 2 WIDGET1...

Hi, The old defined name function of GET.CELL(63,GC!A1) can be used to identify the background color of a cell. Trying to use the same method to identify the font color. Searched high and low but can't find the right index number, i.e. what to change the 63 to. Can anyone help ?. Thanks

Hi everyone, I want to backup my workbook with below codes. First of all, codes are checking backup folder whether or not. If not the folder, being created in C:\ and then being identified. Finally, this code must saveAs active workbook. But not. Where I am making mistake I don't know. Could...

I have a list of comments that is manually entered by multiple people. I need to find which is generic in nature. Is this possible in excel. i know we cannot use any formula for this. Is there a way to do this using macros?

Hi. i'm currently working on my bachelor thesis and i'm now trying to create a formula that gives me the "header", after it has identified the largest number in the set and give me the column header as a answer. <tbody> A B C D E F G H I J 0.5 2 7 2 1 0 2 5 10 3 4 5 5 7 9 2 5 1 3 5 6 8...

Hello, I have a workbook that I am creating to schedule daily trips for my transportation company. I have a worksheet with a different tab for each driver. I would like to make a new tab to function as a FULL TRIP LIST tab that has all trip data and identifies which driver has the trip for...

Hi, I'm currently using =COUNTIFS(A1:A1000000,11,A2:A1000001,21,A3:A1000002,31) but I want to modify it to not only count the number of occurrences of 11,21,31 in column A, but to also list them by row. For example,,, .........A 25.....11 26.....21 27.....31 . . . 15000 11 15001 21...

All, First off, I can honestly say I have minimal experience with VBA, so there might be an exceptionally obvious solution. If there is, I apologize. For background, I'm running Windows 7 and Excel 2013. I've got a workbook with 5 input tabs. This workbook functions like a big "To Do" list...

I have 2 different spreadsheets with very similar information. Both spreadsheets, each row is broken out by customer name. How do I set up Excel to identify the duplicate customers? Thanks in advance. I already did this once manually and it was no fun and took hours.

Good Day, I am trying to decipher a formula that will check in a range of cells to determine if a cell criteria has the identical values in two separate cells. See example: <tbody> Company Debit Credit BX, INC $0.00 $1,500.00 LX, INC $0.00 $28,293.68 FX, INC $0.00 $23,257.00 BX...

Hi everyone, I want to automate the way in which I keep track of which people show up for the weekend hikes based on a simple entry attendance. I have a simple table as follows: <tbody> A B C D E 1 Date 7 Oct 14 Oct 21 Oct 28 Oct 2 Participants Mike Danielle Mike Danielle 3 Melissa Dan...

Hi! I am currently investigating two periods in time: 1990 and 2000, and the change for 3000+ individuals in approx. 20 different variables. In the 1990 dataset I have 3354 individuals that are identified with a code-nr that runs from 10000 to 34907. The 2000 dataset includes some of these...

Hi there, Looking for a bit of help or inspiration! I have a spread sheet with about 6000 items on it. COLUMN A: Order Numbers COLUMN B: ORDER DATES COLUMN C: COUNT (counting instances of order number) Unfortunatley a lot of the dates for the order numbers are duplicated and I am looking...

Hi I am an Excel VBA beginner. I have an Excel sheet with 3 columns. The EmployeeID is in column A and this is repeated for whatever number or records it has. In column B there is a start date, and in column C a "Talent" grade change. I want to output in column D, a result which shows the...

Hi, after some help with identifying data in a large spreadsheet. (i'm using excel 2000 XP i think) I've used a formula i found on this site to identify the count of repeat data i have, which is nicely listed from 1 - about 50. Now i want to identify where there occurs runs of over 6...

To talented VBAers: Any help on the problem below would be greatly appreciated! Concept for my excel sheet: A user to clicks any button on a sheet with (6X4) 24 buttons; depending on what button is clicked, certain information is sent to certain cells in another tab. My problem is that I...

I have an external application that offers the possibility to export files to excel at which time excel opens (is called) and data is written into a new sheet. The user is then to save this sheet for further processing in again a multitude of reports and stuff. Since the date and decimal...