2-3

I have a fairly large workbook (60+sheets) that I'm taking over maintaining. Its got a lot of macros in it that control moving data from entry sheets into databases, and collecting that data into report sheets. I've been successful speeding up several sheets that had macros that took 30+ seconds...

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

Hi, Stuck.... I have 4 rows of data (going across lots of columns). Top row is a series of dates. Row's 2-4 have a set of values in there (just names, each appearing once). Want to find the cell (in row 2-3) with a given name in, then return the date (from the top row of that column). Can...

I'm trying to create an inventory maintenance log where column K will display the number of occurrences of any given serial number in column D. I'd also like the cells to be green when there's 1 occurrence, yellow when there are 2-3 occurrences and red when there are 4+ occurrences. I've been...

Hi guys, Hopefully another quick and easy formatting (or conditional formatting) solution here, but I'm stuck. I have a pretty sizable workbook, with one section focusing on hours worked for a particular task. What I'd like to be able to do is, depending on how many hours are recorded as...