help!

Hi there, I have a worksheet which looks like this: <colgroup><col><col><col span="5"></colgroup><tbody> P/N Description Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 1000 Part 1 5 10 15 20 25 1001 Part 2 2 4 6 8 10 1002 Part 3 3 6 9 12 15 1003 Part 4 1 4 7 10 13 </tbody> I would like...

Hello All, I have been slowly learning to build Macros and cannot seem to comprehend enough to tie it all together for this project. I have a worksheet with 85 Vendors (currently but will grow) all in column D. My worksheet varies from week to week but can be 5000 rows at times and will...

Hi All! We are working on a sheet and want to pull data from sheet 2 based on the date entered on sheet 1 cell A1. The data is arranged on sheet 2 by date. Each cloumn is a different date containing either a staff name in the rows below or off. These are list across 31 columns. In each row...

So I have a set of Data that I need to break up into specific tabs by specific info in one column. I need this data to populate in its proper tab instantly while still remaining in the master tab. I used excel explosion but it does not really help because it would be too time consuming...

I have an Excel spreadsheet with client names and addresses on it. It has grown to over 30,000 rows (one row per record). I am now trying to import it into Access, but Access will only import 448 records before it says there is too much data. Is there any way that I can easily split my data so...

So, I have four different spreadsheets that I compiled into one excel sheet. What I need to do, is create a dropdown menu of what do you want to do: Option A, Option B, Option c, or Option D. So far I had created the drop down menu. However, I can't figure out how to make it so when a user...

Hi all, I am trying (and failing) to find a formula to show me the following: columnA = names of people ColumnB = Date ColumnC = Task number ColumnD = Time what I would like to do is a lookup against the name, and in columnE, show the time of the first task that person did for that date. I...

I just started a job that sometimes requires a lot of excel usage (and knowledge), so I am extremely excited to find this website and such a large collective of Excel brains! <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> Currently, I have an excel...

I have two columns of information, names in column A and the numbers associated with those names in column B. Some of the cells in column A are blank spaces but have numbers associated, I do not want to sum these numbers, I only want to sum the numbers that have names in column A. I know...

Hello all, hope you guys can help. I have been all over the net searching for a resolution with no success. I have 3 coloums of data. A - Month, B - Employee, C - Model My problem is I would like a formula that will give me the most frequent model, ignoring hidden cells. I am using this...

Hi, I am trying to get a very large table to provide countable (0 or 1) or markable "X" calendar year columns to get data for graphing #sites/calendar year. The table contains, for example: Location: start date exp date 2006 2007 2008 2009 2010 2011 alpha 2/2/06 2/2/09...

I have an excel 2007 spreadsheet at my work, its about 30 colums across and contains a couple of thousand clients, one client per row. I'm pretty happy with it at the moment Ive done some (what I would consider) nifty stuff when it comes to summarising the data on there, stuff per month, that...

Hey guys. I've been racking my brain over this for 2 days now, and I think my code simply won't do the trick. What I have is a table in one sheet, which I want to 'break up' into chunks as it is pasted into a second sheet. What I've been doing is copying the item to the sheet, then using...

I'm building a sheet that will allow me to enter an employee's ID number and subsequently return some columns of data that I need to see. The data that I want to be returned will be contained in 2 different sheets within the same workbook and the data in these sheets is updated automatically via...