Copying data from one Excel sheet to another. [Solved/Closed]
Remedial
- Posts
- 2
- Registration date
- Thursday May 7, 2009
- Last seen
- May 8, 2009
Related:
- How to copy data from one sheet to another in excel
- Excel formula to copy cell value from another sheet - Best answers
- Excel copy data from one sheet to another - Best answers
- How to copy data from one sheet to another in excel using formula - How-To - Excel
- How To Copy Data from One Excel Sheet to Another Using a Formula - How-To - Excel
- How to copy data from one sheet to another in excel automatically ✓ - Forum - Excel
- Copy data from one sheet to another in excel based on criteria ✓ - Forum - Excel
- Auto-copy data from one sheet to another in excel - Forum - Excel
20 replies
Best answer
It's as simple as this:
On the sheet you want to copy to go to the cell you want and type = (DO NOT HIT ENTER)
Then go to the sheet with the info and click on the cell you want to copy and hit enter.
And you're done!
Hope this helps :)
On the sheet you want to copy to go to the cell you want and type = (DO NOT HIT ENTER)
Then go to the sheet with the info and click on the cell you want to copy and hit enter.
And you're done!
Hope this helps :)
has helped 1702 users this month- Posts
- 261
- Registration date
- Saturday April 11, 2009
- Last seen
- June 21, 2011
To create form go to visual basic editor (ALT + F11) >>Insert>> Userform
find how to fill controls (text boxes, labels, buttons) into a userform by searching in google
When userform is created and make a macro to show that userform
on clicking the submit button on the form,
find the lastrow in the database sheet (use google) , get all the field values to each cell in the last row
eg. sheets("Database").cells(lastrow+1,1).value=userform1.textbox1.text
sheets("Database").cells(lastrow+1,2).value=userform1.textbox2.text
etc
find how to fill controls (text boxes, labels, buttons) into a userform by searching in google
When userform is created and make a macro to show that userform
on clicking the submit button on the form,
find the lastrow in the database sheet (use google) , get all the field values to each cell in the last row
eg. sheets("Database").cells(lastrow+1,1).value=userform1.textbox1.text
sheets("Database").cells(lastrow+1,2).value=userform1.textbox2.text
etc
ok so after many weeks of fiddling about I finally developed a macro that you tag to a click button (from forms) right click and assign macro. Then paste this into the VB field:
Sub Button1_Click()
Worksheets("Analysis").Range("I4").Value = Worksheets("Amortization").Range("D4")
Worksheets("Amort_Data").Range("N2").Value = Worksheets("Amortization").Range("L9")
Worksheets("Analysis").Range("I6").Value = Worksheets("Amortization").Range("D14")
Worksheets("Amort_Data").Range("P2").Value = Worksheets("Amortization").Range("L10")
End Sub
Using the second line as an example, once the button is clicked it will copy data in cell D$ from my "Amortization" sheet to cell I4 on my "Analysis" sheet. ie if you haven't changed sheet names you would be copying from sheet 1 to sheet 2. For each different cell that you wish to copy to another sheet, you must enter a new line. In my program I have created I have 1 click button that copies 18 variables from one sheet to another. these all have to be entered manually. This works perfectly for me as I have a Loan Amortization on sheet 1 and I wish to copy data outputs from sheet 1 to sheet 2. I have 8 different buttons on my first sheet that perform different actions.
If you need more help please reply to my post here!
Hope this helps
Geoffrey
Sub Button1_Click()
Worksheets("Analysis").Range("I4").Value = Worksheets("Amortization").Range("D4")
Worksheets("Amort_Data").Range("N2").Value = Worksheets("Amortization").Range("L9")
Worksheets("Analysis").Range("I6").Value = Worksheets("Amortization").Range("D14")
Worksheets("Amort_Data").Range("P2").Value = Worksheets("Amortization").Range("L10")
End Sub
Using the second line as an example, once the button is clicked it will copy data in cell D$ from my "Amortization" sheet to cell I4 on my "Analysis" sheet. ie if you haven't changed sheet names you would be copying from sheet 1 to sheet 2. For each different cell that you wish to copy to another sheet, you must enter a new line. In my program I have created I have 1 click button that copies 18 variables from one sheet to another. these all have to be entered manually. This works perfectly for me as I have a Loan Amortization on sheet 1 and I wish to copy data outputs from sheet 1 to sheet 2. I have 8 different buttons on my first sheet that perform different actions.
If you need more help please reply to my post here!
Hope this helps
Geoffrey
Hi
I also need exactly this kind of program made in excel.
I have my cash cards selling shop that deals with about 100 customers. I want to create a data entry form in one excel sheet and store the data as databse in same or another sheet.
Could u please send me a wizard or a model excel file for this.
I would be greatful to you.
Thank you
I also need exactly this kind of program made in excel.
I have my cash cards selling shop that deals with about 100 customers. I want to create a data entry form in one excel sheet and store the data as databse in same or another sheet.
Could u please send me a wizard or a model excel file for this.
I would be greatful to you.
Thank you
Hi Geoffrey;
Would you please tell me is copy and paste possible between 2 different workbooks. I have about 20 workbooks and I want to copy the date from each workbook to the master book as wrbook1,wrbook2.............wrbook20 = master book. in other works between 10-20 rows and about 60 columns from each wrbook1...........wrbook20 should be consolidated into mater work book and master book would have 0-200 rows and 60 columns and contains each wrbook's data individually on one WORKSHEET of master workbook.????????????/
regards
Xaidi
Would you please tell me is copy and paste possible between 2 different workbooks. I have about 20 workbooks and I want to copy the date from each workbook to the master book as wrbook1,wrbook2.............wrbook20 = master book. in other works between 10-20 rows and about 60 columns from each wrbook1...........wrbook20 should be consolidated into mater work book and master book would have 0-200 rows and 60 columns and contains each wrbook's data individually on one WORKSHEET of master workbook.????????????/
regards
Xaidi
- Posts
- 2
- Registration date
- Tuesday August 11, 2009
- Last seen
- August 12, 2009
Hi There
This is exactly what I am looking for to complete a project...
If poss, could you send template/code to Email Id removed for security also.
Many Thanks
Ross
This is exactly what I am looking for to complete a project...
If poss, could you send template/code to Email Id removed for security also.
Many Thanks
Ross
Hi Ross,
Sorry for the late reply, appologies that I couldnt reply to any of the emails, coz I was posted to another country on work ( 3~4 months) and high priority work.
I read all your emails, I will post the draft copy of this excel this evening and by end of this month I will upload the completed version of this excel.
Also, can anyone help me how to upload the excel on this web site (i mean steps or procedure).
I would like to do this coz I got initial help from this site, sure this will help others too.
Regards,
Herald A.
Email Id removed for security
Sorry for the late reply, appologies that I couldnt reply to any of the emails, coz I was posted to another country on work ( 3~4 months) and high priority work.
I read all your emails, I will post the draft copy of this excel this evening and by end of this month I will upload the completed version of this excel.
Also, can anyone help me how to upload the excel on this web site (i mean steps or procedure).
I would like to do this coz I got initial help from this site, sure this will help others too.
Regards,
Herald A.
Email Id removed for security
Im so glad your laughing... yes the one code was not much work "broham" however the other 11 sheets, 32 pieces of code and well I think its 1600 cells of inputed data I had to manually enter... yeah not much work for someone who never used excel before...
Grow up and learn not to bag someone for things they are TRYING to learn themselves, WITHOUT first knowing what they went to to get there.
Oh and I don't sell things people can get for free buddy. It's a University assignment, and I don't much feel like distributing something freely after ive spent about 3 months of sleepless nights on.
Go play World of warcraft if your such a nerd and can do this in your sleep. keep "loling" mate.
Stay Tough
Geoffrey
Grow up and learn not to bag someone for things they are TRYING to learn themselves, WITHOUT first knowing what they went to to get there.
Oh and I don't sell things people can get for free buddy. It's a University assignment, and I don't much feel like distributing something freely after ive spent about 3 months of sleepless nights on.
Go play World of warcraft if your such a nerd and can do this in your sleep. keep "loling" mate.
Stay Tough
Geoffrey
Hi Geoffrey,
I am attempting to create a 'Form' in Excel. I want clients to be able to enter their mortgage data on a single screen. In the background I have created the ammortizaiton schedules for 15,20 & 30 year loans with interest, principal and running balance. I also have a worksheet that contains all of the closing costs associated with refinancing their current loan into a loan product of their choosing.
I don't understand how to use the 'LoanEntryForm' to move the data into the spreadsheet or vice-versa. I hope to move the particulars between the 2 apps and then create ROI charts. So when the consumer enters their data they see graphic representation of how it 'works' in the future.
I am stuck at the point of getting the 'button' in VB to go and grab the data from excel. Or I can't even get the button to send the data into excel so it can do the cruncning...
any advice.
thanks,
K
I am attempting to create a 'Form' in Excel. I want clients to be able to enter their mortgage data on a single screen. In the background I have created the ammortizaiton schedules for 15,20 & 30 year loans with interest, principal and running balance. I also have a worksheet that contains all of the closing costs associated with refinancing their current loan into a loan product of their choosing.
I don't understand how to use the 'LoanEntryForm' to move the data into the spreadsheet or vice-versa. I hope to move the particulars between the 2 apps and then create ROI charts. So when the consumer enters their data they see graphic representation of how it 'works' in the future.
I am stuck at the point of getting the 'button' in VB to go and grab the data from excel. Or I can't even get the button to send the data into excel so it can do the cruncning...
any advice.
thanks,
K
I'm trying to do something similar as well for a gardening project where I need data entered in one page and moved to an array of other pages containing specific data from the page entered, I would love the template and advice if this template could be modified as such.
EX: bed a we harvested 5 lbs squash I need that info to jump to another page just pertaining to bed A.
My email for the template is Email Id removed for security
Thanks in advance
EX: bed a we harvested 5 lbs squash I need that info to jump to another page just pertaining to bed A.
My email for the template is Email Id removed for security
Thanks in advance
- Posts
- 6
- Registration date
- Friday October 23, 2009
- Last seen
- May 7, 2010
oh God,
i'm searching for this for sooo long...
I've got the same problem, and I need it for my work.
can anybody please send me this worksheet?
i've got 1. (main) sheet where the data is suposed to be,
and 2.,3., and 4. sheets are data which are supposed to be inserted into the first sheet.
so it should extract data from (i.e sheet 3(3. row) ) and put it in sheet 1 in desired rows
please, please
thank you in advance..
e-mail: Email id removed for security
i'm searching for this for sooo long...
I've got the same problem, and I need it for my work.
can anybody please send me this worksheet?
i've got 1. (main) sheet where the data is suposed to be,
and 2.,3., and 4. sheets are data which are supposed to be inserted into the first sheet.
so it should extract data from (i.e sheet 3(3. row) ) and put it in sheet 1 in desired rows
please, please
thank you in advance..
e-mail: Email id removed for security
- Posts
- 261
- Registration date
- Saturday April 11, 2009
- Last seen
- June 21, 2011
- Posts
- 4
- Registration date
- Wednesday August 12, 2009
- Last seen
- August 13, 2009
I also would appreciate a copy of the template for this as it is exactly what I've been wracking my brain on for the last 2 months! Thanks much!
- Posts
- 46
- Registration date
- Sunday February 7, 2010
- Last seen
- April 15, 2012
Hi
I also searched the net and also would like to get hold of the info on how to setup a form that can save the data and be re-used. I would appreciate it if you can help.
I also searched the net and also would like to get hold of the info on how to setup a form that can save the data and be re-used. I would appreciate it if you can help.
All,
I'm looking for similar type macro. I'm brand new on this.
Scenario: I have set o data with a unique set of data in column A, Also, same coloum A has multiple data set as well. A good example: Manager 1 has 10 employee( first name, last, Address, Phone …..) Manager 2-- the same. I would like to create a macro that can create every manager into their own worksheet or a workbook. I really need help as I have no Idea where to start.
Any help will be appreciated.
Thanks,
Mikel
I'm looking for similar type macro. I'm brand new on this.
Scenario: I have set o data with a unique set of data in column A, Also, same coloum A has multiple data set as well. A good example: Manager 1 has 10 employee( first name, last, Address, Phone …..) Manager 2-- the same. I would like to create a macro that can create every manager into their own worksheet or a workbook. I really need help as I have no Idea where to start.
Any help will be appreciated.
Thanks,
Mikel
Thank you