Related:
- Moving data to the next empty cell
- Tmobile data check - Guide
- How to insert picture in word without moving text - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Clear only the formatting from the selected cell (leaving the content) - Guide
1 response
Select
ActiveCell.Offset(1, 0).Range("A1").
I have used this in an Excel spreadsheet to select the next lower cell in column A (after pasting data from one spreadsheet to another and transposing the data). It's been awhile since I created the macro, but seems there is a "relative reference" component. Hope this helps.
ActiveCell.Offset(1, 0).Range("A1").
I have used this in an Excel spreadsheet to select the next lower cell in column A (after pasting data from one spreadsheet to another and transposing the data). It's been awhile since I created the macro, but seems there is a "relative reference" component. Hope this helps.
Sep 17, 2009 at 04:20 PM
My hospital uses a check request form created in Excel and now a department wants to create a spreadsheet with only 4 of the fields i.e. Date - Company - Invoice # - Amount .
These are part of the originial form field and we would like another worksheet with these as headers and of course populate the information no matter how many times those fields are changed. I can use =(sheet1!H10) and it will have the same information until I add a new check request with different Dates - Company - etc.
The new worksheet will have the field headings but needs to move down one row once the origianl form is saved or changed?
Thanks in advance - ROB