Related:
- Moving data to the next empty cell
- Tmobile data check - Guide
- How to copy data from one excel sheet to another - Guide
- Excel arrow keys not moving cells - Guide
- Copying data from one Excel sheet to another. ✓ - Excel Forum
- Arrow keys scrolling in Excel ✓ - Excel Forum
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.
17 Sep 2009 à 16:20
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