Upendra asks how to transpose data while keeping a live link between the original data and the transposed data. A normal Paste … This article was gathered automatically by our news bot. We help YouTubers by driving traffic to them for free. The featured image in this article is the thumbnail of the embedded video.
Shana has a dashboard report with 50 worksheets. She has a menu with hyperlinks to the 50 different worksheets. Here’s the … This article was gathered automatically by our news bot. We help YouTubers by driving traffic to them for free. The featured image in this article is the thumbnail of the embedded video.
How can two people edit the same Excel workbook at the same time? This feature has been introduced in 2017 and is available to … This article was gathered automatically by our news bot. We help YouTubers by driving traffic to them for free. The featured image in this article is the thumbnail of the … Read more
Michael has a question: “I have Actual and I have Budget Figures that are combined; what I would like to see Actual Minus Budget, … This article was gathered automatically by our news bot. We help YouTubers by driving traffic to them for free. The featured image in this article is the thumbnail of the … Read more
The Question: “How do I generate the next Invoice Number?” Microsoft Office Online offers a great number of Invoice Templates. However, none of those templates has a Macro to pull the next Invoice Number. Today, in Episode #1505, Bill shows us how to ‘Macro Enable’ our Workbook and then create a short VBA Code routine … Read more
David from Florida has two workbooks that he wants to combine. Both workbooks have the same field in column A, but then … This article was gathered automatically by our news bot. We help YouTubers by driving traffic to them for free. The featured image in this article is the thumbnail of the embedded video.
Here is a how-to for importing Excel files from a folder using Power Query (Get and Transform). It’s fairly easy to do. HOWEVER, in this example, I’m sharing a folder with someone who starts putting goofy stuff into the folder and they break the Power Query query and the process. Now what? One move is … Read more
Ron wants to LOOKUP up Data from one workbook to use in a current workbook. Using HLOOKUP and Shortcuts to navigate between Workbooks, Bill shows us how to build a LOOKUP Formula that pulls the Data from the Table in the second workbook. Follow along with Episode #1650 to see how this is done. …This … Read more
Say that a co-worker writes a VLOOKUP to a closed workbook and refers to $A$1:$S$99,19 to grab a value from column S. The co-worker sends you the linking … This article was gathered automatically by our news bot. We help YouTubers by driving traffic to them for free. The featured image in this article is … Read more
Kuldeep wants to select every third cell for 1500 cells The macro code to union all 500 cells is too long and causes a compile error! Solution: Build 1, blank, … This article was gathered automatically by our news bot. We help YouTubers by driving traffic to them for free. The featured image in this … Read more