Hi everyone, I'm an Excel newbie. I was just wondering if it's possible to create a button with a certain value in the background. So that whenever I click the button, the number or word or whatever appears in the cell where I'm currently located. This saves me from having to manually type. Or is…
Hello, am I correct in understanding that the native lenses for the EOS M 50 are the RF- M ? The RF lenses without the M are full-frame, right? And which lens for the EOS 50M would be suitable for portrait and product photography? Low-budget. Thanks
Hello everyone I have the following problem: I've created several macros in an Excel workbook and given them names, for example, Test1, which I start with a button to which I've assigned the macro. Now, for some macros in the workbook, the name has suddenly changed from "Test1" to 'Filename'!Test1.Test1. This, of course, means the…
Hi, I created a link to an Excel file in Excel, but when I try to open the file from Excel, it says I can't open it because I don't have Excel. But I do have Excel! How did I link the file? Insert tab > Object > Create from File > Insert File How…
Hello, I have a question about Excel. For example, if the value "0.0" is in column "K" in rows 5 and 8, should these rows be deleted completely? Can I write a macro here? Like CTRL+x? Kind regards
Hello, I would like to automate a work step in Google Sheets or Excel (although I prefer Google Sheets) – adding up data. I enter the data into a cell and then categorize it. The image shows what I mean: Each number is assigned to a category. Here, I've color-coded the different categories for clarity….
Hello , I need a macro code to make the table more manageable. If the "Total" row contains a 0 (see image, highlighted in yellow), this column (see image, highlighted in yellow) should be hidden. Unfortunately, I have no idea about Marko's writing. Thank you for your help
Unfortunately I had to lower the quality so it could be included here.
I work in the catering industry, and we have a lot of slices without calorie counts. A woman wanted to buy five of them but wanted to know the calorie count first. The manager has no idea either. It's made with coconut flakes and coconut milk, agave syrup, cashews, and chocolate coating. Vegan, gluten-free, and…
Good day, There is the possibility to assign the CTRL key to a macro key. I have an HP 430 Programmable Wireless Keypad. It has macro keys, but is there a way to program one of the keys to become a CTRL key? I hope I was able to define my problem clearly. Googling the…
Hello, I have two Excel: In file A, column A contains various codes, and then columns D to G contain data. In file B I now need a macro that, based on a code in a cell (let's say "XY2345" is in C1), copies all values from columns D to G from file A into…
Hello everyone, I would like a dynamic footer or header. The workbook contains a long list of error messages, approximately 32,000 lines. These are filtered using the Filter() function according to user requirements. A PDF can then be created from this and assigned to the relevant departments. Now I would like to enter the filter…