Search results

Hi all, I'm not quite sure how to graph this, since Excel keeps throwing back errors at me. All the values at the top are X values - 1,2,3,4,5,6, etc. Each value below the X value should be a Y value. What I want to do is graph each of these values, so in the current example I'd have a...

Hi, The organization I have been developing for is in the process of migrating from Office 2003 to Office 2010. It's a large organization, and thus I'm unable to convert my Access databases into a 2010 format without leaving a large number of folks behind -- and I'm not in I/S so I can't...

I am having an issue with file sizes due to a complex series of formulas that I'm trying to solve. Basically, I have an 'Entry' worksheet, which new entries are added to. Based off of each entry, a formula checks to see how to categorize each record that is added. Another formula creates a...

I haven't popped in here for awhile, but I hope you had a happy birthday Rabbie! :)

I have data that gets copied via macro from one area to another. However, when it copies, it converts the date format to a general format. I don't want users to have to then reapply a date format to the specific column. Is there a way I could assign a column's cells to be for a date using VBA...

No, this one isn't a recorded macro. B67 is simply what the dataset runs through for the number of bins at this particular plant location. Below that are various other calculations and cells, and I don't want to copy/analyze anything below that point. The Range("c7").Select...

I'm pretty close, but the next time I execute the code it doesn't paste to the newly selected Cell, but rather up to C7 again. Sheets("Entry").Select Range("c7").Select SendKeys ("{End}") SendKeys ("{Down}") SendKeys ("{Down}") ActiveCell.Select Dim...

Well, it now brings it to that spot which is perfect! But when I execute the code again, it should paste it in that bottom activated cell -- so the list would grow larger as more is copied. It just seems to copy directly over instead of the appropriate activated cell. I suspect I mangled...

I only posted a portion of the code. There is indeed a copy statement and that part works quite well. If it's more helpful, here's the entire code instead of just the portion I was seeking assistance with: Sheets("Manipulations").Select Range("A3:B67").Select Selection.Copy...

Hi all, I'm trying to paste information from one sheet to another via macros, then have the first empty cell below the data insertion point to be selected. C7 is where the data set I'm working with starts, but currently the code just copies over what I've already got instead of adding it to...

So I've been delegated the unenjoyable task of trying to get a Microsoft Excel file to do what one would typically do with Access. It sucks. In my poking around Excel, I found Microsoft Query buried deep within the menus, which is able to query spreadsheets much like Access would. In fact...

How can I convert this into being a static date stamp? It does what I need it to do, but when that particular field is a zero, I need to be able to have a static date stamp when that happens. I've found a few posts about static date stamps, but none of them are very useful. Any idea how...

Any thoughts on using Pivot Tables with this? I'm getting frustrated, because it seems like this is a weird combination of vlookup and hlookup. Both formulas can look in the range I need, but neither formula does what I need it to do.

Simple issue here with vlookup but it's giving me a headache! :rolleyes: Anyhow, I have various columns showing the capacity of a bin for every item on every date. If a bin capacity drops to 0, I need to be able to return what date that occured on -- and there are 31 columns labeled with...

Thanks! I ended up with this, which does exactly what I need: Option Explicit Sub Marine() Dim r As Range Set r = Cells.SpecialCells(xlCellTypeFormulas, 16) r.EntireRow.Hidden = True Set r = Nothing End Sub

I have a table that is calculated out. However, cases arise in which 2 cells have a #VALUE! and one cell has a #NA!. This behavior is normal and expected. What I'd like to do is be able to hide the entire row if those conditions are met. How would I go about doing this? I'm trying to piece...

No, it doesn't work. The cells contain a combination of text and values. Some cells may read "no" while other cells will see a date. I need to count both in the same formula.

I have a spreadsheet with a wide range of values. I'd like to count the cells which have values, regardless of what the value may be. I'm not looking to count blank values, and I'm not looking at counting specific values. Just the number of cells which have a value in them, regardless of...

I still get the error. I am utterly lost as why the query runs perfectly but the report using the query does not. :(

I modified that too (accidentally posted the wrong thing), and it just tells me that "The specified field 'TblShipTo.[Street Address Line 2]' could refer to more than one table listed in the FROM clause of your SQL statement.