track

I have a large number of receivables in a spreadsheet that I am trying to locate. I can use relative reference to work down the spreadsheet one record at a time. Would anyone know how to take the active cell, populate a search engine, and auto-populate the name into it and conduct a search. This...

Good Afternoon, I am trying to make the calendar we use in excel to track orders more user friendly. First I would like to click on a cell and have a sub window to pop up asking for the below Customer (Text) PO# (Text) Time (Text) Assay (Drop down) Order# (Number) With those answers I’d like...

Hi there, I'm using Excel 2013. I was looking up other questions, but simply couldn't adjust those codes to my case. Issue: Column 'BN' contains dates. I would like these dates to be updated automatically whenever I modify a cell in column 'BP'. Format should be yyyy.mm.dd Additional info...

I have many sources of data for our database and would like to track the dates we receive these sources. Initially the Excel source is renamed and copied to our network via an Access VBA script, which checks for the latest source. From here, once it finds a source it runs an Excel macro which...

Hi So I have the following: Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting There is another tab in the excel. I don't have it on me. Let's say I have a tab named "Track" and the picture above is Tab named "Time." In the Track tab, I have a column called "description of...

I am trying to track the the total number of changes that occurs in a cell that contains a formula. The cell uses the formula COUNTIF(E$5:E$1356, "Incomplete"). to track the number of 'Incomplete" items there are, so this number with increase and decrease with the change of the status. I am...

Hi to all, I want to say from the start that I am new and I don't have any exprerience to VBA language!. However I know clearly what I want to do. THE GOAL: I am using EXCEL 2003 and I want to record the values from a group of cells when they change, at a different sheet, let's say LOG_ELEV...

Hey guys, I am having some trouble figuring out the best way to approach this problem. I need to create 1-6 tables on one sheet from 1-6 data sets on the same sheet. to create the charts, I use a button that runs a macro to make the chart. I also have a "reset button" which deletes the chart of...

Greetings Experts.. Is there a way to customize the "Track Changes" feature in Excel 2010 to change the fill color to YELLOW for the cell that was changed? I'd also like to keep the log file for changes that excel automatically creates. Thanks!

I could really use some help. I have a form that is currently in Word format (I can also have it in PDF). This form is used within a hospital by many staff members to record and document general and detailed patient information regarding transfers to acute care facilities. Is there a way to...

Is there a template or something out there that will help me track my daily tape backups? I just need something that will list the date, the 3 backup jobs, successful/failed and a notes section. Anything out there like this?

Hello, I am trying to put multiple values into a single cell. I have looked into Array Constants but I may need some additional help with implementing the solution. I am working on Windows 7 Excel 2007. Let me start out with what I am trying to accomplish, and perhaps there is a better way to...

I am currently tracking changes in a workbook which is shared. I would like to see who has changed what and when. I am having the trouble of 'employee' apprearing in the changes box where i would like the actucal user name to apprear. Can anyone help with this? Thanks Paul