Search results

Hi all, I looked through older posts but didn't see the same issue I seem to be having, which I'm sure is something very simple! I created a pivot table with a few column headings: date, po, customer, total and I want to group the dates by month or week..... I found a great post by Chandoo...

I did mean workbooks........ yes the module name has been changed and I did store it in my Personal.xls workbook but it doesn't seem to be working correctly. Hmm.... I'll play around with it and peruse the site you linked to and I'll keep you abreast of my progress. Thanks again for all...

Thanks Luke, I'll try the Ctrl+Alt+F9 thing but now I have yet another question! LOL I realized that the Vlookallbooks would be very useful in other spreadsheets that I have; all of them looking to the item number log, but when I try to use it I have to use the FX & select from the UDF in...

Hi Luke, Thanks again, I think that will work but it really does cause performance issues so I'm opting not to use it ..... I'm putting a link to the other spreadsheet & telling people to open it before entering the item #. I really appreciate all your help!! I'm sure we'll "speak" again...

Hi Luke, I opened both files later in the day; the item # log as a read only and what I found is that the fields on the shop order log that had the vlookallbooks formula didn't automatically populate BUT, if I entered the cell and went to the end of the formula and hit enter it did populate so...

Uh-oh ..... *totally red here* ..... I told you I'd be posting again...... LOL I just didn't expect to do it so soon! YIKES.... I just closed both of the files and was playing around to see exactly how well this would work. I knew that the item # log would have to be open but I didn't...

Ok, so I closed the file, reopened, and entered the formula multiple times and it seems to be working ....... I guess the old turn it off and on again worked!! LOL I cannot thank you enough for all your help with this!!! I'll be posting again I'm sure! LOL Have a fantastic evening!

Me again.... ok, so I got the error I just told you about but.... it did find the data ..... how weird is that? I don't want to get that error all the time though ..... any thoughts?!

I tried it again by using the FX instead of typing it in and I get the following VB message: User-defined type not defined; what does that mean?

Ok, I copied and pasted your code above and entered the following forumla: =vlookallbooks(G2,A:C,2,FALSE,"Item Number Log.xls") the item I'm looking up is housed in G2 and I want to look at all sheets of the item number log in column A. The result will come from column b and then, once this...

Thanks again for the response..... I need to look at multiple workbooks across multiple sheets; does that make a difference in the code? You were correct that the missing ( was a copy/paste error. I guess I had the syntax correct as I was doing exactly what you spelled out above...

Ok, I changed the name of the module and that seemed to work for one issue as when I hard enter the vlookallbooks formula I do get a 0 instead of an error. However, it seems like it's only looking at the current workbook and current worksheet, which is certainly not what I need it to do...

Vlookallbooks is available so I guess it's a formula syntax problem. I selected it and entered info and now I got a 0 instead of the #NAME? error; I'm not sure why though. I'm headed to lunch --- I'll be back in about a 1/2 hour. Thanks!

Hi Luke, Thanks for the response...... let's see, in the pane on the left it's in a module in the appropriate file, I've renamed the module to vlookallbooks. In the right pane, at the top in the first drop down area it says (General), in the second drop down it says vlookallbooks. Does...

Hi everyone, I'm new here and am hoping you can help as I've been over and over this and cannot figure out why it's not working. I'm am VERY NEW to VBA so it could be as simple as placing the code in the wrong module or not "linking" it to the worksheet properly which is why I'm reaching out...