.offset1

Hello, We are looking for assistance in moving data from one workbook on the network to another WB on the same Network. We currently use the code below to move data from the active workbook to Sample Request Log.xlsm. in the code below we pull data from various cells across the active sheet...

I use this code from one worksheet to open another worksheet and transfer data from selected cells Workbooks.Open Filename:="R:\General\COVER SHEET_Protective\Protective Packaging Order Log.xlsm", Password:="PP", WriteResPassword:="PP" Set LastRow = Sheets("ORDER...

Hello to all, We have a workseet that is filled by multiple users. Once 8 cells are filled out the user clicks on a submit button. An oder entry Log is opened and the data from the 8 cells from the worksheet are placed onto the next open line on the log. should not matter in this scenario...

I have a Userform that transfers data, sort of. I need to change the code, as it doesn't do what I need it to do. What ends up happening is that it creates a new row at the end of the table (good!). What it doesn't do, is add the userform data to that new row, but instead overwrites the data in...

Hello, The formulas in the VBA code below work perfectly for what I'm wanting to achieve; however, I notice that it's terminating 1 row before the last line of data. I thought the "offset" might have something to do with it so when I deleted it, it wreaked havoc, haha. I think the "offset" is...

I am not well versed in VBA. Below was made for me a while back and works like a charm. However, I would like "Input Box" option removed and replaced with something I can just go into the code and modify the key word(s) myself as most of what I need moved is currently limited to the same 6...