Programming

xlookup & paste a picture
..I want to lookup a picture(coded) and paste(copy) it to the worksheet I am working on. Both data's are on excel 2003 but different file names. e.g my w/sheets are "baskets.xls" and pictures are "basket pictures.xls" ... 2 Mar 2010 04:37

Extend Custom function
Hi Someone was kind enough to post this custom function. What it does is assess if a lookup is valid if it is it does one thing, if not another. However if I have a fomula which either the true or false component returns an #NA then I get a #VALUE! Error. I don't want to wrap the custom function with an if ... 1 Mar 2010 18:46

Parse only text from column?
How do I extract just the text from a column? For example, if one of my columns = "1234 abracadabra" and I want just the "abracadabra"? ironryan77 ... 1 Mar 2010 17:38

Copy a worksheet
H Guys can you help. i want to copy a sheet from a closed book into an open book via vba macro. Example is - run code to open the workbook, copy the only worksheet in that book and paste it into an existing sheet in a workbook that is already open. Can u help Thanks Nev ... 1 Mar 2010 19:53

Macro to change pivot field with latest value
This is a re-post as my questions hasn't been answered by anyone... Hi there and thank you in advance for any help. I have written a macro that changes (hides / shows) fields on a pivot table. One of these changes the field used for the page fields section of the pivot table. However, when i add a field to th... 1 Mar 2010 16:29

Extract only text from column
How do I extract just the text portion of a column? For example if column contains: "123 abcd", how do I get just the "abcd" in a new column? ... 2 Mar 2010 18:07

"Undo" creates bizarre behaviour
hello, I have a workbook with multiple sheets with comboboxes. On sheet1 I have a combobox linked to a named cell in A6, on sheet2 another combobox linked to a named cell in A10. The names of the cells are not shared between sheets. On certain sheets, when I click undo, I found that it writes the content of s... 1 Mar 2010 14:09

Filter/Display only certain rows of information based on a use
Hi Russell, Thanks for your response and to answer your questions, It is to protect other's seeing confidential data and currently I do not have a column with the Manager's names. Any suggestions you might have on how to relate manager to employees would be great also. "Russell Dawson" wrote: Is the ... 1 Mar 2010 12:34

Insert Row without changing formulas
In Row(1), I have some formulas. As an example, "{=MIN(IF($B $3:B1994,$B$3:B1994))}" is in Cell B1. Row(2) contains some headings. I have code as follows, that copies data from one sheet and inserts into another sheet: ss.Rows("2:" & 2 + dta - 1).Copy ds.Rows(3).Insert Shift:=xlDown This causes the cell s... 1 Mar 2010 11:25

auto generate sheets in a workbook from list using a master sheet
i need to automaticly generate time cards using a name list from the name sheet and the master timecard sheet so it will put the all the info from the name sheet into the cells of the master and change the tab name to the name on the list so they can input their own times onto the sheet and do this for the name... 1 Mar 2010 09:11