Pages

Search

Excel Help Forum - Excel General: [SOLVED] Match data between sheets?

Feed2Mail notification - new post on Excel Help Forum - Excel General
[SOLVED] Match data between sheets?
Is there a function that can match of unlinked values between sheets 'prod' to 'data', then pull the associated data into the B column? The best was I can describe is through the .xls Attachment 189508 (http://www.excelforum.com/attachment.php?attachmentid=189508) *last question of the...

Excel Help Forum - Excel Programming / VBA / Macros: Copying a sheet without copying the command buttons

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Copying a sheet without copying the command buttons
I have a macro that makes a copy of a sheet, changes the name of the workbook and closes. When it copies it includes the 4 command buttons that are on that sheet. How can I copy the sheet and note the command buttons? I have tried changing the properties to don't move, but to no avail they CB still...

Excel Help Forum - Excel General: Display textbox on clicking any chart data series

Feed2Mail notification - new post on Excel Help Forum - Excel General
Display textbox on clicking any chart data series
Hi i have a worksheet with a scatter chart and two series. is there a way upon clicking on any of the series to have a textbox displayed and preferably docked underneath it ? (please see attachment. can someone provide a UDF or point me to right direction please .

Excel Help Forum - Excel Programming / VBA / Macros: Applying conditional formating across multiple columns independently

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Applying conditional formating across multiple columns independently
It was suggested that I cross post my question from the formulas forum here. I was given a solution that saves quite a bit of time but a macro may be better? After many hours of google'ing I come before you defeated. The attached sheet is an array of various sales offices and their sales...

Excel Help Forum - Excel General: IF THEN statement and Tables

Feed2Mail notification - new post on Excel Help Forum - Excel General
IF THEN statement and Tables
I am attempting to create a table in excel that will automatically fill out another table depending on the outcome. For example, if A3> 0, then A1, but if it is not, then check A4>0, then A4, etc. I've attempted it in this manner so far, but when I get past the first one I always seem to get...

Excel Help Forum - Excel Programming / VBA / Macros: userform that will search name and pull results from a seperate workbook

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
userform that will search name and pull results from a seperate workbook
I have created a basic spreadsheet with multiple columns and will be entering data daily to the fields. However, I will have others using the form to search for people on the spreadsheet and they would prefer having a command "Search" button for a person(s) name instead of using filters. I have a...

Excel Help Forum - Excel General: quickest method for dynamic link to closed workbook

Feed2Mail notification - new post on Excel Help Forum - Excel General
quickest method for dynamic link to closed workbook
Im looking for the quickest known solution : I need to link to over 52 separate workbooks and pull back a number of cells. the problem is that depending on what week we are in some workbooks will not exist. but i need the links to stay live then update when the sheets do exist. Ive tried...
Subscribe to: Posts (Atom)