| Date | Auteur du sujet | Sujet | Extrait du message |
|---|
| 26/03/2020 à 17:04 | corriedtoppin | Comment créer automatiquement des tableaux sur des feuilles Excel | Merci je le comprends. J'utiliserais le modèle que vous avez créé pour créer un autre classeur. Ce que j'ai essayé de faire, c'est de copier les macros dans un autre classeur. Cependant, lorsque j'ai copié la liste des pays dans votre classeur de modèle. Cela fonctionne à merveille. Merci encore pou... |
| 26/03/2020 à 10:28 | corriedtoppin | Comment créer automatiquement des tableaux sur des feuilles Excel | Oui je l'ai fait. Merci s'il vous plaît voir ci-dessous. Merci... |
| 26/03/2020 à 02:17 | corriedtoppin | Comment créer automatiquement des tableaux sur des feuilles Excel | Au travail toute la journée. J'ai suivi vos instructions mais je reçois une erreur. Veuillez voir l'image ci-dessous. Je ne sais pas si c'est moi ou non. Vraiment approprié, merci encore... |
| 25/03/2020 à 09:08 | corriedtoppin | Comment créer automatiquement des tableaux sur des feuilles Excel | J'ai une inquiétude, quelqu'un pourrait-il m'aider si vous le pouviez. J'ai plusieurs feuilles de calcul qui ont les mêmes tableaux uniques sur chaque feuille. Le problème est: [list =] Comment puis-je créer automatiquement les mêmes tableaux sur les différentes feuilles de calcul et [/... |
| 21/03/2020 à 02:17 | corriedtoppin | Ignorer le collage de formules de cellules vides | Ca fonctionne. Merci beaucoup. Encore. J'ai été sauvé par les super-héros d'Excel. Merci encore... |
| 21/03/2020 à 01:35 | corriedtoppin | Ignorer le collage de formules de cellules vides | Je suis désolé. Le problème a changé. Les documents que j'ai postés avant. est les mêmes documents que j'utilise. Je ne suis pas sûr de ce qui semble être le problème. Que recommandez-vous avec les documents que j'ai publiés? Merci d'avance. Voir photo d'erreur... |
| 20/03/2020 à 20:52 | corriedtoppin | Ignorer le collage de formules de cellules vides | Ce dossier d'objectif est-il ouvert lorsque vous lancez la macro à partir du dossier PMI? "Oui" s'appelle-t-il HeatWave est-ce l'extension xlsm? "Oui". Cependant, il épelait "Heatwave". n'est-il pas protégé? "Oui". Il n'est pas protégé... |
| 20/03/2020 à 19:40 | corriedtoppin | Ignorer le collage de formules de cellules vides | Merci de votre patience et de votre réponse, en me permettant de le faire correctement. Veuillez voir la photo ci-dessous de l'erreur que je vois actuellement. Je suis coincé car j'ai une idée de la façon d'avancer. Que voulez-vous que je fasse? Merci d'avance... |
| 20/03/2020 à 11:54 | corriedtoppin | Ignorer le collage de formules de cellules vides | Je suis désolé. Je veux dire: "L'exemple de fichier contient peu d'informations et les macros n'ont pas fonctionné sur le fichier d'origine... |
| 20/03/2020 à 11:51 | corriedtoppin | Ignorer le collage de formules de cellules vides | Helle. Merci pour votre aide. Je prends l'exemple de ce que vous avez fait et cela fonctionne. Le problème ici est le suivant. Le fichier d'exemple contient peu d'informations et les micros n'ont pas fonctionné sur le fichier d'origine. Sur la «feuille de calcul de la vague de chaleur», différentes... |
| 19/03/2020 à 00:21 | corriedtoppin | Ignorer le collage de formules de cellules vides | Toute la journée, j'ai cherché en ligne une méthode pour résoudre mon problème. Ci-dessous, j'ai deux exemples de feuille de calcul Excel. L'un est "PMI" et l'autre "Heatwave". Mon problème ici est le suivant: Voudrait copier des données de PMI et les coller dans la canicule, mais en même temps saut... |
| 17/03/2020 à 12:24 | corriedtoppin | Run-Time Error"9" Subscript Out of range | I've taken your suggestions. I've renamed all my tables for better understanding. And I've added macros, and it WORKS!!! I'm new to Excel and I'm starting to discover that this program is a very powerful software that I will enjoy. Thanks again... |
| 16/03/2020 à 13:08 | corriedtoppin | Run-Time Error"9" Subscript Out of range | Good morning, Hope all is well. I don't know if you all can help me. I am stuck and I don't know what to do? I have one more document that is challenging to fix. It was working before. I don't know what is the reason of the problem in Macros. How do you want me to proceed? Thanks in advance ... sp=s... |
| 15/03/2020 à 11:35 | corriedtoppin | Run-Time Error"9" Subscript Out of range | If you are open, I would like your support once more. I have a similar problem on my first plead above on macro error message. Where Jean-Eric have help me so wonderfully. I have tried all the codes that I have received in the pass, none of them have worked. Please view document on the link below, i... |
| 13/03/2020 à 00:55 | corriedtoppin | Run-Time Error"9" Subscript Out of range | I really don't know what to say. Jean-Eric. I really appreciate your continual support, always. You demonstrates a character of a true friend. One that shows your personality with out complaints, dependable, reliable and supportive. It seems like procrastination is your worst enemy. and helping othe... |
| 12/03/2020 à 02:26 | corriedtoppin | Run-Time Error"9" Subscript Out of range | I have a problem. I don't know if you can help me out here. I have a macros name "Update Sheets" on one sheet #1 "PMI" When I click the Macros to copy and paste each (country, date and value) into each work sheet database. I get an error message that states, "Run-Time Error"9" Subscript Out of range... |
| 09/03/2020 à 14:20 | corriedtoppin | Expression.error the column of the table wasn't found Excel | I see. The website site have updated it column to "Reference". Before it was "Blank" no wording under the column. Thanks again. Greatly appreciated... |
| 09/03/2020 à 00:21 | corriedtoppin | Expression.error the column of the table wasn't found Excel | "Hello, What is the object of the "Added prefix" steps? Regards." Is to change the "Reference" column to "DATE" format... |
| 08/03/2020 à 23:12 | corriedtoppin | Expression.error the column of the table wasn't found Excel | Can You help me out with something. I am trying to refresh my data links. But I am getting an error that says: "expression.error the column of the table wasn't found" How can I fix this? Please if you are welling, please view. Thanks in advance...... |
| 28/01/2020 à 15:38 | corriedtoppin | How Can I make Pop-Up Reminders Open Up With Excel | ... |
| 26/01/2020 à 12:06 | corriedtoppin | How Can I make Pop-Up Reminders Open Up With Excel | I have a code below. I'll like to modify the code, in two areas: #1. Pop-up notification, ten days before, the person on, Cell F "Data" of Birth, Cell G: "Baptism Date" & Cell H: "Anniversary". And #2 Pop-up on the same date. How can I do that? Thanks in advance... |
| 20/01/2020 à 16:12 | corriedtoppin | Challenge creating heat map-data carries there own unique values | Let me start over. Good day excel world. I have a concern.Below link have a list of countries that carries each country unique data. Consumer Confidence - Countries - List Now let's take the 1st two example: and My problem is this: How can I use 3-Color Scale "Heat map", using conditional formatting... |
| 20/01/2020 à 12:30 | corriedtoppin | How to customize a 12 month rolling average to a 12 moving rolling percenta | Jean-Eric Hello Good day. You are a wonderful person. Here I am, seems embarrassed sometimes to post questions or statements, most often and someone still answered my plead. I real appreciate it lot. The excel you have create is wonderful. Both you and LouReeD are wonderful. I now have two excel fil... |
| 20/01/2020 à 12:13 | corriedtoppin | Challenge creating heat map-data carries there own unique values | I'm in the process of creating a 3-Color Scale "Heat map", using conditional formatting for investment purposes. But I am having some challenges in creating the heat map, because each data carries there own unique values and may differ extremely from each other. See Link below, of countries listings... |
| 18/01/2020 à 01:07 | corriedtoppin | How to customize a 12 month rolling average to a 12 moving rolling percenta | Ok Thanks... |
| 18/01/2020 à 00:33 | corriedtoppin | How to customize a 12 month rolling average to a 12 moving rolling percenta | Thanks for your swift reply. I am not sure if I make the error. However, I am getting an error. Will like to place the formula in column cell "F". How do you want me to proceed? Thanks... |
| 17/01/2020 à 23:46 | corriedtoppin | How to customize a 12 month rolling average to a 12 moving rolling percenta | Excel Pros. I am not sure if you can help me. I just don't know. My problem here is this: How can I convert the 12 month rolling average: See below. =IF(ROW(A13)<13,"",AVERAGEIFS($C$2:$C$5000,$B$2:$B$5000,">"&EDATE(B13,-12),$B$2:$B$5000,"<="&B13)) To a 12 month percentage rolling average: I... |
| 17/01/2020 à 14:49 | corriedtoppin | How Code Or Macro Can I Use To Substitute Text To Column | Jean-Eric I love you, I love you, I love you... Thank very much. Much thanks to you and your patience, working with me especially with my English language. You should become my excel teacher. Greatly appreciated Thank you again. God Bless You... |
| 17/01/2020 à 13:50 | corriedtoppin | How Code Or Macro Can I Use To Substitute Text To Column | Hello Jean-Eric, Thank you for your swift response. Please view the sample file below. Please note: the raw data is on cell "A1" and The extracted data example is on cell "N" and cell "O" There are many excel workbook I need to extract data. How can I create a universal code to extract each one. Tha... |
| 17/01/2020 à 12:26 | corriedtoppin | How Code Or Macro Can I Use To Substitute Text To Column | Currently I have Many Raw Data as an example below to section out. What's beautiful, all the following data are similar: Here is an example in row "1", in column "A" only : 0: {c: 9, close: 9, yield: null, referenceDate: null, date: "1997-03-01T00:00:00", …} In this Case: How can I Keep the values o... |
| 16/01/2020 à 00:17 | corriedtoppin | Reference Same Cell From Multiple Worksheets With VBA Code & Paste it as a | It's working. It's working. It's working. Thank you, Thank you & Thank you very much Greatly appreciate your patience and support Thank you... |
| 15/01/2020 à 23:29 | corriedtoppin | How to copy and transfer data into multiple worksheets under its own histor | This is the updated version Below: Sub Update_Sheets() Dim sh1 As Worksheet, sh2 As Worksheet Dim i As Long, j As Long, f As Range Set sh1 = Sheets("NON_PMI") For i = 2 To sh1.Range("A:A").Find("*", , xlValues, , xlByRows, xlPrevious).Row Set sh2 = Sheets(sh1.Range("A" & i).Value) Set f = sh2.Range(... |
| 15/01/2020 à 23:10 | corriedtoppin | Reference Same Cell From Multiple Worksheets With VBA Code & Paste it as a | I am stuck. I don't know what to do. I am not sure if you can help me. My problem here is this. I want to extract data from 50 worksheets that have it values in cells "F2 &G2" the name of the workbook is: "Countries Indicators #1 NSB (1)" Next I want to paste and lock ALL data, "F2 & G2" cells as a... |
| 15/01/2020 à 22:21 | corriedtoppin | Reference Same Cell From Multiple Worksheets With VBA Code & Paste it as a | What do you want me to do... |
| 15/01/2020 à 21:32 | corriedtoppin | Reference Same Cell From Multiple Worksheets With VBA Code & Paste it as a | The VBA code below: reference same cell from multiple worksheets.However, How can I modify the code reference to copy "50 worksheets", that has values in both "F2 & G2"and paste the same values into a new workbook as a list on "C2 & D2" downwards" Here is the code to be modify: Sub AutoFillSheetName... |
| 15/01/2020 à 19:30 | corriedtoppin | Link data from multiple worksheets which uses the same cells values | Sub Test1() Workbooks.Open (Filename: = "C:\Users\Corey\Desktop\Anton Heatwave\PMI\Countries Indicators #1 NSB(1).xlsx") 'Filename to adapt End Sub Still nothing... |
| 15/01/2020 à 18:46 | corriedtoppin | Link data from multiple worksheets which uses the same cells values | I don't know. That's the name of the excel file: Countries Indicators #1 NSB (1) Sub Test1() Workbooks.Open(Filename:="C:\Users\Corey\Desktop\Anton Heatwave\PMI") 'Countries Indicators #1 NSB (1).xlsx End Sub I am only getting and error... |
| 15/01/2020 à 15:30 | corriedtoppin | Link data from multiple worksheets which uses the same cells values | This is the file name: Sub Test1() Workbooks.Open(Filename:="C:\Users\Corey\Desktop\Anton Heatwave\PMI") ' Countries Indicators #1 NSB (1) End Sub... |
| 15/01/2020 à 15:20 | corriedtoppin | Link data from multiple worksheets which uses the same cells values | Ohhh. I'm sorry going to try... |
| 15/01/2020 à 15:08 | corriedtoppin | Link data from multiple worksheets which uses the same cells values | Sub Test1() Workbooks.Open(Filename:="C:\Users\Corey\Desktop\Anton Heatwave\PMI") 'Filename to adapt End Sub The above code... |
| 15/01/2020 à 13:52 | corriedtoppin | Link data from multiple worksheets which uses the same cells values | The test code don't seems to work. Error states: Compile error: Syntax error. How can I get around this... |
| 15/01/2020 à 11:52 | corriedtoppin | Link data from multiple worksheets which uses the same cells values | I did change the file name, "(Filename:="C:\User\FullPath\WorkbookBname.xlsx")" to (Filename:="C:\Users\Corey\Desktop\Anton Heatwave\PMI"). and I made and error to state where I want to paste the values. from: .Range("B" & Rw) = WbSource.Sheets(Country).Range("F2") .Range("C" & Rw) = WbSource.Sheets... |
| 15/01/2020 à 11:12 | corriedtoppin | Link data from multiple worksheets which uses the same cells values | I have a problem. I want to extract data to create a list from workbook (B) into another workbook (A). NB: Using the "=" sign is hard and long to extract data. So my point is: On workbook (A), I have a list of countries names from row A2 to row A51 Next. On workbook (B). Each country has it own "wor... |
| 15/01/2020 à 11:09 | corriedtoppin | How to modify code | Thank you very much. This code works wonderfully... |
| 14/01/2020 à 22:37 | corriedtoppin | How to modify code | I have a problem. I received updated data from excel web, through power queries table. Every week the data updates selective rows, depending on the time of the month etc. Each row of data represents a worksheet historical data. Now my problem here is this: when I run macro code. it copies and paste... |
| 06/01/2020 à 09:09 | corriedtoppin | How to copy and transfer data into multiple worksheets under its own histor | The Code below was place in VBA, NON_PMI worksheet. For some reason, it don't seems to work. You quote: "' pourquoi la colonne O???" = 'why column O ??? Like the worksheets: "PMI" & "NON_PMI". I'm in the process in creating other online updating report of each country. Now each country worksheet sho... |
| 06/01/2020 à 03:38 | corriedtoppin | How to copy and transfer data into multiple worksheets under its own histor | I must say again. I appreciate your support. I made some changes on your code you have recommended, to solve my problem since the last time we have chat. I'm currently preparing to create multiple worksheets similar to the "PMI" worksheet "you have help me solve", to capture data online, then paste... |
| 04/01/2020 à 01:47 | corriedtoppin | How to copy and transfer data into multiple worksheets under its own histor | It works wonderfully. Thank you, Thank you Thank you I really appropriate it a lot... |
| 04/01/2020 à 00:38 | corriedtoppin | How to copy and transfer data into multiple worksheets under its own histor | I have a huge challenge here & what I am going to asked may sound impossible. "Well, for me I should say". Here are the steps: Step #1: The data below is updated automatically into excel worksheet. The name of the worksheet is: "PMI". Step #2: Every Country represent a worksheet. "Yes. I know. It so... |