beginner help

I am brand new to anything to do with Excel programming via VBA. My issue sounds simple but I don't know how to fix it. It is for my job and I feel there is an easier way to do this. I have a workbook that has 177,000 records. The example below doesn't show all the columns on the original and...

Hey guys, I have been cracking my head last 2-3 days with the following coding, but just aren't able to understand the syntax. The code works well, but I am a beginner in this. Any help on the meaning of it would be great. Thanks! Code: Sheets("Payment Schedule").Range("A2:f" &...

Hello, I have a beginner's question about multiple regression, so a stats question really. I've only recently learned the basics of linear regression and I still have the following nagging doubt. I'd like to analyse some sales data for the purpose of forecasting future performance. My dependent...

Hi, i am trying to create a macro that will move data entered on three separate sheets to one master sheet either as the new line is entered or upon saving the document. The file has 3 different agents adding data to a shared document for internal audits, then a master audit sheet where the data...

Hi, i am really new to macros but I am trying to create a macro or formula that will insert a table at the end of an invoice letter. The letter length can vary depending on the inputs and i would like to have it simply move to right below the last line of text. i have the table on a reference...