Posts by Intranet

    Your time would be better spent learning the basics of Excel and working with data. I build complex reports in Excel with out using VBA.

    I understand your observation. I don't have your knowledge but I have some knowledge of excel. But I never dedicated myself to VBA, until now. This is an urgent and complicated case and the person asked me to be able to improve performance in a super short amount of time. When I have time, I will have to rebuild it all over again, with data storage and stuff, in a different way. But for now... it is what it is. However, I have already reduced it in a first phase from 300mb to 100mb and then to 50mb, saving in binary.

    But I promise I will learn VBA through the forum. I like it.


    The data sheet looks more like a form than a data sheet. The name sheets resemble data sheets but have one sheet per name is a very inefficient way of maintaining data.

    I know it doesn't look like a data sheet and that it's possibly not the best way to store data. But I tried to give you an example as simple as possible without loading you up with unnecessary information. This example is part of a much larger workbook that is about 300 MB. I'm reformulating everything to be lighter and faster. I understand that it may seem ineffective to you, but that's how the workbook is. And for me, that even didn't know what a macro was two months ago...well...:D

    I am sure that I will perfect this workbook because I find this subject very interesting and I will spend more time absorbing all your knowledge.

    Thanks you again


    YOU ARE THE MAN! Thank you, thank you, thank you! :)
    It works perfectly.

    Thanks again

    There's no data in the data sheet and it does not even resemble a data sheet.

    Read this

    Hi Roy

    I don't understand why you don't see the sheet. I can see the sheet perfectly, in my office 2019, when looking at the attachment that is in my post. Anyway, I resend it again. I changed the name to be more understandable. As for the rules, I had already read them. But thanks anyway.


    I'm new to the forum and also a VBA apprentice. I'm building a workbook but as I'm an apprentice and I have little knowledge, I'm asking for your help to build a macro. If it's not possible, I understand and appreciate it. Sorry for the English. It's not my native language. There are several dozen worksheets, but I just illustrate it with three options to explain the problem.

    The first worksheet (BASE) is the list of people and their ID. The DATA worksheet is where I enter the data. The other worksheets I named it with each person's name. The criteria is to copy the data from the DATA worksheet, and save it in the worksheet corresponding to the name. For this I need a macro to be able to identify the worksheet where it should save the data that corresponds to the name, which is in the DATA worksheet. The data must be pasted on the last blank line.

    To identify which worksheet, I thought of writing “NAME” in a cell and concatenate this cell with the variable that is in the worksheet's name field DATA. This would result in a name equal to the worksheet where the data should be saved. The macro would then use this result as a way to identify the target worksheet. The ID is automatic. PROC. Nº, DATA and PRODUCT CODE are manually entered by me. In the attached example I already include my idea.

    Could someone help me to create a Macro with these functions? Can you give me other ideas?

    Thanks and sorry for the long text.