end of data

Hi, I am new to VBA and these forums but since every question I put in Google directed me here I figured I'd just make my own account. I can't find a way to use the END, SHIFT+ENTER function from VBA. This is important because the file contains empty cells and the amount of colums varies per...

All, I know there are several help topics for VBA end row -- but, I'm still relatively new to VBA, and I'm not sure if I can insert one of them into the macro that I've recorded to automate one of my daily reports. I generate a report each day that summarizes all of the data M-T-D. Instead...

I'll try to explain my scenario... I'm trying to make a guest list for parties, and I want to have these guest lists on a single worksheet. I want to have 2 macros that do 2 things: 1) Prompts to ask how many guests (and then copies the 4th row of the list (row 5) and pastes x times before the...

I have a single workbook with 2 worksheets: Azn_TrainA {Has row data A-J which I need to copy and paste at the bottom of Azn_TrainA} Extract {Column E has numeric data which states which row I need to copy from Azn_TrainA} I would like this to be a loop until all data from Extract has been...

Hi Everyone, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have an issue with a large data set but will try to explain it the best I can. <o:p></o:p> <o:p></o:p> In my template, in column A, I have a measurement which continues all the way down to 1002...

Hello, How do you select a set of data that is thousands of rows but has blank cells interspersed with cells with data? For example, lets say I have data in A2:A3000 but I only have data in ever 10 cells (e.g. data in A2, A12, A22, etc.). How would I quickly select all of this data? I know...

Hello - I am trying to format a file using a Macro - the file is exported from another source and the amount of records is variable. I want to copy and paste the first record onto the end of the file - I tried using copy, then cntl-end. However, the Macro records this as a static row so the...

I have a spreadsheet with 19 worksheets (Excel 2007) and each worksheet has a date in column A, text in Column B, and numbers in columns C, D, and E. (It's my budget) At the start of each new month I need to go to the bottom of the data on each tab (Each tab has a different "Bottom of Data"...