Search results for query: *

Alright, I got it to work. I just pasted your code in verbatim. Instead I needed to add the "xlToLeft" instead of "xlLeft". I appreicate your help and will reward you with a star.

I'm so sorry, Skip, but I got a run-time error of '1004': Application-defined or object-defined error. I replaced the old ws.[IV]... code with what you posted up above and got that error. I apologize if this is getting frustrating...

There is an intermediary step which is done via VLOOKUP on all of the products that are dumped, which makes compiles all the data from the dump. The VLOOKUP table then has a Pivot run on it. Unfortunately, I was not the one that created this table. I am just trying to set up some code so that...

Skip, For some reason when I run the code now, it still is pasting the information into column A, even though you placed a "X" there to prohibit this from happening. I am getting data pasted into A4 down the entire A column, which of course messes up the sheet. Any thoughts? By the way, I...

Skip, Normally I would completely agree with you! However, the sole purpose for this exercise is to dump data so that I can use it to run a pivot table. The number of rows varies each week because the number of unique products that are sold varies each week. Once the data is in the...

OK, I ran the code and the good news is that there are no more errors. The bad news is that the code doesn't do quite what I had anticipated. If you look at my original code, the first week should be pasted at cell B4, not A4. Week 2 is pasted in G4, Week 3 in L4, etc... Also, I need each...

Now I am getting an error on the following line: ws.[IV4].End(xlLeft).PasteSpecial xlPasteValues "Run-time error '1004': Application-defined or object-defined error" I made the changes that you and PHV recommended.

One more clarification: The Range used in my code, ("A7:E49") was only an example of a range of what that particular file would use. This needs to be replaced by the "dynamic code" that I was referring to in the previous post. Also, I tried running the code that you gave me, but I got a type...

Skip, Your answer for question 2 was perfect! Thank you very much for that. Let me try to clarify question 1. Each workbook ("hedging week ?.xls" where ? is 9 different files from 1 to 9) has data to be copied starting with A7 and ending with column E. The last row to be copied depends on...

I set up the following macro to open up corresponding files and copy them into a worksheet. Sub Run_Hedges() ' ' Run_Hedges Macro ' Macro recorded 3/15/2010 by Chris Vesta ' ' Keyboard Shortcut: Ctrl+h ' Range("B4:AT150").Select Selection.ClearContents Range("B4").Select...

Thank you for your perfect response! I very much appreciate your help. This was driving me nuts! Thanks again!

I am very close to solving this, but for some reason I just can't get the final detail. I have 6 cells that designated as shown below: L14 M14 N14 O14 MIN DAY 1 SEC DAY 1 MIN DAY 2 SEC DAY 2 P14 Q14 R14 MIN DAY 3...

Perhaps I did not give enough detail to my request. For those of us who use Access, when a user uses a drop down combo box, sometimes it is possible to allow the user to "see" two columns of data. The first column is the information that gets returned to the cell. The second column is...

I am used combo boxes in the past with Access but am not familiar with how they work in Excel. I have two lists in Column E and Column F of a worksheet called "Lists". I have a combo box in cell E2 of a worksheet called, "2009", that I would like to populate with the two lists. I would like...

I have tried it. What I don't like about it is what it does to the headings. I don't like the drop down boxes, which is why I wanted to hard code it as shown above.

Here's my solution: Sub copydata() Dim lrow As Long, lrow1 As Long Dim rng As Range lrow = Cells(Cells.Rows.Count, "A").End(xlUp).Row Rows(lrow).Copy Range("A" & lrow + 1) lrow1 = Cells(Cells.Rows.Count, "A").End(xlUp).Row Set rng = Rows(lrow + 1)...

Alright, getting back to work. The list function is definitely a very efficient way to do this, however, I have blank columns to keep groups of data separate. I tried creating multiple lists, however, I have headings and subheadings involved. For example, Row 1 will have a main heading such...

Skip, I'm just a 28 year old guy who enjoys helping people whenever asked and I'm assuming that you do as well otherwise you would not be on here. I never have a problem looking things up, but when it's what I may consider a "quick hitter", I just ask the question because I figure the other...

Sorry, I did not know the expectation was for me to look it up on Google.

Sure, many times. Why?