I have created a spreadsheet for data collection which is utilising
userforms for this purpose. The data is for the last financial year
(06-07) and the date options in the combo box reflect this (using
month only) When selected though the year changes to 07 from 06 (ie

Can anyone tell me how to get a drop down menu (say called 'Feeds') on the
Standard toolbar between the Data and Window drop downs and from that menu
items so that I can 'attach' them to macros
Many thanks

Maybe somebody can help me with this.  I tried looking at other
postings but could'nt find something like this and my VBA programming
skills are not good enough to be to manipulate other postings code.
I have two lists, both have three attributes, date, location, and

I want to copy an item from on cell in worksheet3 (CO2) and then paste it in
worksheet1 (CO2) then copy this all the way down to the last row. I would
like to do this in a macro. I have tried recording this several ways, but it
is not reliable.

how do i make a reference to a single specific cell (for example D1)
in a amcro
thanks

Here I got one of my older VBA-Projekts, which now causes an error due to
changes of the system it is running on. Normaly it should be solved easily,
but at that time I used a password to protect it's code :-(
I already tried to use my default passwords, but none of them works. It

Ok here si the biggie for me.
Say I have data in A3:A8, in C4 ihas a formula that seeks out data from
another area in sheet and will return Data matching one or more of the  Cells
in A3:A8. How can i make it  make the  data  that matches in A3:A8 Bpld or

Looking for a sub which can strip away the "Sheet" prefix from all sheets
bearing such names, eg sheets named as: Sheet2, Sheet3, Sheet4 ... will be
renamed as simply: 2,3,4 ... Thanks.

hi! I have an array with numbers. i want to sort the array based on the size
of the numers. how can i do this? do I need to write a function for it or
does it exist in vba already? please help!

This does just what I want:
Sub TestTransfer()
Sheets("Pages").Cells(10, 5).Copy Destination:=Sheets("Schedule").Cells(5,
2)

I made a dll and I used it in VBA
Like this:
Declare Function currentMilli Lib "exceltest.dll" () As Long
It's working on my computer in any folders.

I know how this works and why
=index(CostList!$A$1:$E$200,Match($A54,CostList!$A$1:$A$200,0),Match($M$1,CostList!$A$1:$E$1,0))
but now I have confused my self to the point i can not  progress. What I need
to do is  look up a single Cell, Match it to a column and then  get the

Hello, Given the following macro:
Sub mastertest()
Dim ws As Worksheet, cell As Range, rng As Range
   For Each ws In ThisWorkbook.Worksheets

Is there anyone on this group who has any experience with programming Excel
<-> SAP interfaces in VBA.
have a good day
Tomas

I have the following code below which posts various values that are
within sheet "Report" to a sheet called "Database"
How would I cnage the code below to post the same details except to
different worksheets depending on the value in Report K6?