Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Appending Data from one sheet to a master sheet

I have a worksheet in excel that performs calculations, based on my input to
certain cells, and creates a table. I want to click a button and paste that
table to a 'master' table. I want to repeat this same step for different
inputs and have excel append each new table to the bottom of the 'master'
table.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Appending Data from one sheet to a master sheet

Try assigning this to a button

TABLE and MASTER TABLE will have to be changed to thr names of your sheets
and the range A1:E10 will have to be changed to the range of your
calculation table. It also assumes that your master table starts in column A
and always contains data.

Sub AddDataToTable()
Dim iLastRow As Long

ThisWorkbook.Sheets("TABLE").Range("A1:E10").Copy
ThisWorkbook.Sheets("MASTER TABLE").Select
iLastRow = ThisWorkbook.Sheets("MASTER TABLE").Rows.Count
Range("A" & iLastRow).End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub

gusto79 wrote in message
...
I have a worksheet in excel that performs calculations, based on my input

to
certain cells, and creates a table. I want to click a button and paste

that
table to a 'master' table. I want to repeat this same step for different
inputs and have excel append each new table to the bottom of the 'master'
table.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
appending master list data tabylee via OfficeKB.com Links and Linking in Excel 2 December 24th 09 09:08 AM
appending master list data tabylee via OfficeKB.com Links and Linking in Excel 0 December 23rd 09 03:26 PM
Showing Specific Data from Master Sheet to Another Sheet Parker Jones New Users to Excel 1 July 10th 09 02:01 AM
appending to second worksheet from a Master Sheet Driver Excel Programming 1 November 19th 03 03:04 AM
Appending data from one sheet to another. Simon Excel Programming 3 November 13th 03 07:32 AM


All times are GMT +1. The time now is 05:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"