Posez votre question
Liste des messages Discussion Liste des forums
Signaler

Excel Movement

Jon - 8 Feb 2010 à 10:16 - Dernière réponse le 8 Feb 2010 à 21:10 venkat1926
Hello,
I have a workbook that has 10 different sheets in it. In this the first sheet in "total information", then "sheet1",..."sheet9". It has columns A thru X filled with data. I would like for it to move the active row to the specific sheet all dependent on what is selected from column Y in a drop down menu of the active row. Of course the list is "sheet1" thru "sheet9". So if I select "sheet3", it moves the data to "sheet3" in the first available line on that sheet. Once complete the active row from totals would be removed.
Lire la suite ...

Excel Movement »

J'ai une réponse
Ajouter un commentaire

Meilleures réponses

 Excel Movement - Rechercher

 List of excel formulas - Fiches pratiques

Basic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM cell A1 to...

 How to compare two columns in excel - Forum

Best answer: user vlookup formula if you have same name in second column =vlookup(select any one name in column A prefer first name , then select full range of column B then ,1,FALSE)

 Excel vba timer - Fiches pratiques

VBA A simple second Timer In VBA, there is Timer feature available,but you can create one very easily. In a module sheet: Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'For example: Start / Stop the timer every...

 Excel filter not working - Forum

Best answer: The following also solves the problem: Instead of selecting the Row that you want to apply the autofilter on, Select all the columns (A, B, C ...) and then apply the autofilter The above solution does work however, but I Think this is much ea

 Excel formula list - Forum

Best answer: Hello BEAR833, I think you will need indirect referencing, a tricky way browsing through your sheets. I can not tell you if there is a more easy way, below is my tip. First you need a list of your worksheets. For that, I wrote a simple Visual

 Count days in excel - Forum

Best answer: How can count dates between 2 cells in excel, 1jan - 2jan to count as 2 days.

 Compare excel spreadsheets - Forum

Best answer: Did you try this tip ? http://en.kioskea.net/faq/sujet-5278-how-to-compare-two-workbooks-worksheets It may solve your problem without using any macro

 Microsoft excel product key - Forum

Best answer: Hi, The key mentioned on the back of your laptop on a sticker is the Windows product key not the Office product key. The Office package installed on your computer is just a trial version thus if you want to keep and use it you have to purchas

 Excel - Find and Replace a Range - Fiches pratiques

Excel - Find and Replace a Range Issue Solution Note Issue I want to find and replace a range of values on excel? Can anyone let me know if this is possible? Solution I have this in my project but i can replace a range of...

 Movie Label 2010 - Télécharger

Movie Label 2010 is a new software released by Code:Aero Technologies. It will allow you to manage all your movie files in a more efficient way. Movie Label 2010 will get all information about Tv series and movies and automatically download them. It also has an inbuilt search engine for searching more easily all details about your movies and series! It also organizes all your movie files which will be easy for you to find them in your machine. Features: Organize your movie l

 Excel - Prepare grades from marks - Fiches pratiques

Excel - Prepare grades from marks Issue Solution Note Issue I am a teacher. I entered marks of my students in a column in excel-2007 work sheet. I have to prepare grades from the marks. Marks from: 80 to 100 is "A" grade. 60 to 79...

 Sony Micro Vault Excellence 16GB USB 2.0 - Guide d'achat

USB, 16384 MB

 Teaching-You Microsoft Excel XP And 2000 - Guide d'achat

Edutainment

 Sony Micro Vault Excellence 8GB USB 2.0 - Guide d'achat

USB, 8192 MB

 [Excel] - if then else with multiple criteria - Fiches pratiques

[Excel] - if then else with multiple criteria Issue Solution Note Issue Essentially, I would like to determine a numeric value (1-9) for the letters of the alphabet. Returning the number value in relation to a name. example: if:...

Plus
Trier par :   Vote | Date | Date décroissante 1 réponses
Meilleure réponse
+1
moins plus
venkat1926 732Messages postés June 14, 2009Date d'inscription 24 July 2010Dernière intervention 8 Feb 2010 à 21:10
little confused. you have validation list in column Y in sheet called "total inforamtion". You select any one of these cells choose one from the list for e.g Y5 and the activecell(Y5) value is "sheet2"--Y5 is the activecell.
you want the whole row of Y6 that is 5th row to copied in sheet2.
If this assumption is correct use this macro 

Sub test()
Dim sh As String
With Worksheets("total information")
sh = ActiveCell.Value
ActiveCell.EntireRow.Copy
With Worksheets(sh)
.Cells(Rows.Count, "a").End(xlUp).Offset(1, 0).PasteSpecial
End With
Application.CutCopyMode = False
End With
End Sub

 Ajouter un commentaire - Permalink (#1)
Ajouter un commentaire
Haut de la page
Créer un nouveau sujet » Répondre au sujet
A voir également
supinfo