Search results

I have a simple workbook with two worksheets, "Sections" and "Equipment." I would like to copy the "Section No." and "Section Description" columns to the "Equipment" worksheet only if the "Equip?" column says "Yes." I would like to do this without having to do a macro if possible where it...

I have a very basic workbook with two worksheets. Both worksheets have two text boxes that will contain the same content. The text boxes will be filled out on the first worksheet. I would like the content to automatically appear in the text boxes on the second worksheet. I have scoured...

Lohith, thank you very much for the link. I read the thread in detail but it appears my code is written slightly different. It doesn't like "textbox1" below. I have two textboxes, how does it know which is which? Set targetSheet = PayAppSOV.Sheets("SOV") Set sourceSheet =...

I have two workbooks, BookFile and PayAppSOV. Both workbooks have an identical worksheet called "SOV." I would like to import the values from BookFile "SOV" into PayAppSOV "SOV." I actually have this functionality working using the code below: Sub ImportSOV() ' Get customer workbook...

Hmmm... E7:E30? The issue with the Macro lies in the Data Analysis worksheet. E7:F21 is supposed to be the results of the Advanced Filter from B7:B21. That is where I am getting the error in the Macro. Do the merged cells in rows 5 and 6 impact the Macro if they are never referenced in...

I just had a thought, do any merged cells in the entire workbook impact a macro? I noticed that UnmergeAllCells() did unmerge some of the cells on other worksheets.

I tried running UnmergeAllCells() and I received the following error: Run-time error '1004': Application-defined or object-defined error I have uploaded the workbook below. The issue lies on the Data Analysis tab where I am trying to advance filter. Another oddity, the zeros in the left...

Hui, that is the crazy thing. I have no merged cells in the entire worksheet that I know. I just received a macro to identify any merged cells on the worksheet. It works if I just manually run the advanced filter.

I have used the macro recorder to write a simple macro to use the solver, advanced filter, etc. The macro worked perfect and then I added the advanced filter portion and now it is giving the following error: Run-time error '1004': Cannot change part of a merged cell I don't get this because...

I apologize it has taken me so long to respond, I had to temporarily table the project for other responsiblities. SirJB7, your solution worked until it got to Tables,G64. It returns $3,600, the highest bonus, for all zero values. This technically doesn't matter because vlookup will never...

SirJB7, my apologies, I didn't realize the "Introduce Yourself" thread was frequently read by forum members. I will venture over there shortly and introduce myself. On a side note, I ended up using advanced filters as a solution to my problem!

I have a table that will always have Qty. 15 entries. At times, some of the table entries will have a zero value. I would like to create a new table that only has the non-zero entries. Your help is greatly appreciated! https://www.dropbox.com/s/ec45a22267j16jc/Desired%20Outcome.xlsx

I just read the sticky posts... :) https://www.dropbox.com/s/t9jhbow1rb9bs36/Store%20Monitor.xlsx

I am an Excel novice, but enjoy learning through websites like Chandoo.org. We own several Jimmy John's and I am attempting to build a spreadsheet for calculating a manager's bonus based on four performance based categories. I can't get the vlookup function to work correctly and I think it is...