Search results

Column B = Employee initials. Column H = Parts run per jobs in rows 2 through 8. Data from another 60+ employees follows this representative batch. Employee initials will always be in column 2 and will always be in the row above the first line entry for job numbers and parts manufactured...

I've discovered a follow-on problem. When my job numbers break into the 20000 and above, range, Excel will not recognize them. Jobs numbered 19999 and below work in the formulas I've tried, but injected the number 20000, 20001, and above don't. All cells formatted the same. No differences in...

Sheet names are consistent. Only job data changes within each feeder sheet. Changes are dynamic and occur two or more times a day, depending on job completion status. (We're trying to provide near real-time data to our production leads.) Regrettably, I can spell "VBA", but cannot program in...

Follow-up Example: Customer Feeder Sheet #1, Columns A through D, enter the following data. Row 1: ABC, 4/5/10, 12345, 4A123 Row 2: BCD, 4/8/10, 23456, 4B123 Customer Feeder Sheet #2, Columns A through D, enter the following data. Row 1: XYZ, 4/15/10, 34567, 4C123 Row 2: CDE, 4/18/10...

1. First few columns are the same for all feeder sheets. After D, columns are not in fixed locations. Due date for one customer may be in M, but may be in J for the next customer, based on specific customer needs. However, column C always contains job number. 2. Only one entry. Example...

Okay, you amazed me, yesterday; here's another. Multiple worksheets. Column headings vary in column placement among the sheets. I need to find data based on a job number. I enter the alphanumeric job number into cell c3 (example) on a master spread sheet. The formula needs to search across...

Amazing! First, to get a response. Second, to get a response that quickly. Third, the response actually worked. Much thanks. I'll be telling others of your website!

Formula in progressive monthly results cells is =SUMIF($D$2:$D$99,$D121,F$2:F100), changing as the months evolve. Therefore, where nothing has happened, return is nothing; I suppose, "zero". However, the line chart I'm using to visualize progression still displays the zero values; meaning...

Yours is the easiest Excel help site I've ever found. (Just found it this morning.) I know enough about Excel to be considered very good by others, but 'dangerous' to myself. Will be posting a question if, in the next few minutes, I don't find my answer among your other posts. Looking...