Need Individual Sheet Data to Copy to Main Sh
Closed
Peter T
-
May 31, 2011 at 09:09 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 1, 2011 at 05:59 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 1, 2011 at 05:59 AM
Related:
- Need Individual Sheet Data to Copy to Main Sh
- How to copy data from one sheet to another in excel automatically - Guide
- Macro to copy data from one sheet to another based on criteria ✓ - Excel Forum
- Digital data transmission - Guide
- How to screenshot excel sheet - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
May 31, 2011 at 09:35 PM
May 31, 2011 at 09:35 PM
not clear how things are but what ever you are trying to do seems to be doable with a macro
May 31, 2011 at 09:41 PM
May 31, 2011 at 09:49 PM
May 31, 2011 at 10:02 PM
'
' ToDirectory Macro
'
' Keyboard Shortcut: Ctrl+d
'
Sheets("Directory").Select
ActiveCell.Rows("1:1").EntireRow.Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
ActiveCell.Select
ActiveCell.FormulaR1C1 = "='Allstate RF'!R[-1]C[2]"
ActiveCell.Offset(0, 1).Range("A1").Select
ActiveCell.FormulaR1C1 = "='Allstate RF'!RC[1]"
ActiveCell.Offset(0, 1).Range("A1").Select
ActiveCell.FormulaR1C1 = "='Allstate RF'!RC[6]"
ActiveCell.Offset(0, 1).Range("A1").Select
ActiveCell.FormulaR1C1 = "='Allstate RF'!R[2]C[5]"
ActiveCell.Offset(1, 0).Range("A1").Select
End Sub
May 31, 2011 at 10:18 PM
I think you are trying to do is, duplicate some sheet, then from that new sheet copy some information into your directory sheet. If that is true, then perhaps what u need to do is refresh dir sheet by looping thru sheets or at least looping and inserting if a new sheet is found
May 31, 2011 at 10:34 PM