I'm doing quotes at work and I need to track the data, thus, transferring it to another spreadsheet. However, I don't want to move it manually each time. Every time I fill in a space I want it to move to my Other spreadsheet and go underneath the previous quote/info/data.
How is this done ?
Welcome to the forum.
Why do you need a copy? Each time you create a copy of data you introduce the possibility of errors either human or by an error in coding.
What will this copy do for you that can't be done from the original data directly.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Hi,
As I do quotes I keep a log of each one by Company name,etc.. right now I have a LOG book 2015, and a Quote Spreadsheet. I just want to put in the info once in the spreadsheet data and have it transfer to both places. I suppose I can set it up similar to what I've already been doing by transferring to certain places on my spreadsheet,
Do you have a quicker idea. see attached. There is sheet 1 and 2.. I want the info from the quote to transfer to the log.
In your destinations, make references back to the source data. Excel doesn't "push" data to other sources the data is drawn from a source.
Hi, yes, that is what Iv'e done throughout my work book.. I just haven't done it Between workbooks.. I can do that ! thanks!
The books have to be open at the same time.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks