Excel Tips Function to return the worksheet name

Hi there,

I am trying to return an array of dates and prices from a worksheet function
and display them starting at the selected item.

This is the function I am using to test. I've seen this done by people such
as Bloomberg but cannot work how to do it at all. Any help would be much
appreciated.

Thanks,

Steve

Public Function ReturnArray() As Variant

Dim tempArray() As String
ReDim tempArray(1, 1)

tempArray(0, 1) = "Price 1"
tempArray(0, 1) = "17/07/2006"
tempArray(1, 0) = "Price 2"
tempArray(1, 1) = "14/07/2006"

ReturnArray = tempArray

End Function

Hello, it's my first post here, decided to register and post my problem as everyone looks very knowledgable and helpful on here and I am tearing my hair out trying to find the answer!

I've been Googling and scouring the Excel help files and can find lots of references to functions for finding and removing duplicate values in Excel, but I want to do the opposite and get Excel to report only the duplicate values and leave out the unique values it finds.

In the report I am working on, a new report is generated each month and I copy the data into a new worksheet which has exactly the same columns, formatting etc as the previous month.

Each of our customers has a unique reference number which appears in the first column, and I need to find the 'repeat offenders', i.e. customers whose reference number appears in more than one month.

I would also like the results to appear in a separate worksheet to display which customer reference numbers have been duplicated and which sheets they appear on.

I've created an example worksheet to show what I'm trying to achieve (can't post my original as it contains confidential data), if anyone knows of a way I can get Excel to do this automatically that would be great!

Thanks

Andy

Hello,

I have created a user defined function that requires four inputs. The function works perfectly.

The only thing I would like to add is help tips for each input variable.

So like with built in excel functions in the functions box.


eg under hyperlink function:

there is Link_location and Friendly_name when you go into that field the text below changes to explain what that variable is.

What is the easy way to create forms in different sheets.......

In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......

Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards

J-O

Hello. I recorded the code below to convert pages of workbook to pdf. It works well on my computer but on a co-worker's computer the pdf produced has header and footer pictures shifted slightly down and to the right, showing small areas of white area on his pdf and I do not see this on my pdf produced.

-Any idea what might cause this situation?
-If I have pictures in the header and footer and the pictures are inserted from my desktop,
does this cause Excel issues with those headers/footers on another computer? Is a better
way to load and link the pictures somewhere in the Excel document?
-Is Excel not the best tool to convert to pdf? Would it be better to use Publisher
or even Powerpoint linked to Excel sheets? How about one of the many Excel to
PDF softwares out there?

Thank you.

Sub convpdf()
Sheets(Array("sheet1", "sheet2", "sheet3", "sheet4", "sheet5")).Select
Sheets("sheet1").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Documents and Settings\myname\Desktop\pdf_file.pdf", Quality:= _
xlQualityHigh, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub

Hy guys,

I still work with excel 2007, so, can someone tell me please if the 2010 version shows the formula tips, when we are tipping a formula in the "name manager box", and in the "conditional formating box".(when you use a formula to do conditional formating), like they are shown when we tipe a formula in a spreadsheet cell??
I think that would be a great help

I have a spreasheet with multiple tabs. I am getting the maximum value of a table in a summary tab. The table is present in each tab with different values. I would like to know if there is a way to know from which tab that maximum value came from. (since the table is present in tab1, tabb2 , tab3 for example and the max comes from tab3, how can I know without going through each tab myself, from which tab the value came from?).
Thanks for your help.

Use a function : =IF(AD3="","",VLOOKUP(AD3,Table!$E$2:$G$450,3,0)), return
> value in cell AE3 e.g. = 03
>
> My problem: Try posting this value to another cell using this function:
> =IF(AE3<10,IF(AE3="","","50-0"&AE3&"-"&AB3&"-790-50026-0000"),IF(AE3="","","50-"&AE3&"-"&AB3&"-790-50026-0000"))
>
> The return value always truncated the preceeding zero if I do not use the
> last function
>
> I I know this is not proper. Any good suggest from the Pro thanks.
>
>