another sheet

hello i need a VBA code that gives me a list in cell B20 that contains values from sheet1 coulmn B:B. if value is writen 2 times, so give it to me only once. if value is writen oce, give it to me as well. each valuse only once. thank you!

Hi, I have found help from the Thread the Code is Sub YesMacro() On Error Resume Next Set Ret = Application.InputBox(Prompt:="Please select a range where you want to paste", Type:=8) On Error GoTo 0 If Not Ret Is Nothing Then Selection.Copy Ret.PasteSpecial...

Dear Sirs, Wish you all a Happy New Year! After doing 2 days of searching I'm here for you kind help! Requirement: I want to copy a row range of data to other worksheet. For example- Range(A1:H1) from sheet1 to sheet2. Im am using this code below to do this Sub CopyData() Dim nextrow As...

Hi, I have been trying to copy certain columns of two spreadsheets based on whether or not they match a particular cell, and then paste them in the another worksheet. This is the code I have so far: Sub search() Dim i As Integer Dim j As Integer Dim k As Long Dim counter As...

I want to use column A if there is a number 1 in column A the order is complete and needs to be moved to the last empty row in the completed order tab. I just need a macro to move all completed orders once a day and clear the data that as been moved and move all other rows left to the top of the...

Hi guys, I would like to have a shape visible, if the value in cell B7 is "WE", and hidden if not. With the VBA below, I am able to do that. HOWEVER, when the content of B7 equels the value in a cell in another sheet, it does not work - only when I write in cell B7 myself and hit Enter. Can...

Residential/nursing homes who fail to meet standards are placed on an improvement plan. We monitor against the standard throughout the lifetime of the plan. Providers can take time to progress their plans and consequently, in any month we visit we may find that a home has either "met" or...

Hello everyone, I am trying to create a series of hyperlinks through a loop without specifying sheet names. This is what I have so far: <CODE> Sub Main() LastCol = ActiveSheet.UsedRange.Columns.Count LastRow = ActiveSheet.UsedRange.Rows.Count For j = 2 to LastCol Worksheets(1).Hyperlinks.Add...

Dear All, I turn to you, because i ran into some troubles. I want to get the value from certain cell and put it into listbox. Here is the code i am using I get permission denied when the for cycle starts. If i have the values of the cells in the same sheet everything works great. Private Sub...

I have a Master_sheet with lot of data column D is DATE ([$-409]d-mmm-yy;@) & column G is (=D-today()). In O1 date ([$-409]d-mmm;@) & R1 date (=DATE(YEAR(O1),MONTH(O1)+3,DAY(O1))-1). I want is when i date any date from O1 (drop down list). Only column A, B, D, E & F data which falls between...

Hi, I have two excel files, the first is 'Old_tenders' and the second is 'New_tenders'. Both contain the same columns about tenders, however, New_tenders includes new rows that are not included in Old_tenders, I need to find these new rows and put them in Sheet 2 of the New_tenders file. The...

Hi, I have two excel files, the first is 'Old_tenders' and the second is 'New_tenders'. Both contain the same columns about tenders, however, New_tenders includes new rows that are not included in Old_tenders, I need to find these new rows and put them in Sheet 2 of the New_tenders file. The...

I think this one's a sequel to my last thread - http://www.mrexcel.com/forum/showthread.php?t=616832 [Yeah, I know i'm really d*mb. Sorry!] credits to my saviors SteveO59L and Snakehips I'll just make this simple to understand. *Again, I have first sheet, named "SUMMARY" *On Column A, I have...

I've got almost one hundred cells with existing drop down lists. I need to cut each cell and move it to another sheet without having to redefine the link to the list data. How can I do that?