Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-28-2015, 12:33 PM
sidbisk sidbisk is offline Keeping track of the original file when you copy/paste Windows 7 32bit Keeping track of the original file when you copy/paste Office 2010 32bit
Novice
Keeping track of the original file when you copy/paste
 
Join Date: Aug 2015
Posts: 2
sidbisk is on a distinguished road
Default Keeping track of the original file when you copy/paste

Hi!

I have to copy paste an extensive amount of data from multiple workbooks and worksheets to a summary workbook. What I am looking for is a way to double check if the data that I past in the summary is from the right workbook, or display the file name.

Example



Workbook1.xlsx contain 2 worksheets each containing 4 different sets of data
Workbook2.xlsx contain 1 worksheet with 4 sets of data

Now I have to form the summary.xlsx by picking the first set of workbook1.xlsx worksheet1, first set of workbook2.xlsx, first set of workbook1 worksheet2, then move to the second set of data, etc...

I know some of you would code the process in a macro or something, but with the different files and switching from on the the other using different worksheet, I don't trust the automatic process.

I found out the past link method the other day and I believe it is part of the solution as it actually display the source of the data in the fx area of the cell. The missing element for me would be to have in the summary workbook a column that display the file name display in that fx area so I don't have to look up every cell to double check if I actually paste the right thing at the right place.

I tried the =cell function but it display the name of the workbook I am calling the function from or in the example case summary.xlsx

I want something that will display in the summary.xlsx for the data that I paste workbook1.xlsx or workbook2.xls, if I can also get workbook1.xlsx worksheet1 that is even better.

Thanks for the reply !
Reply With Quote
  #2  
Old 08-31-2015, 02:06 PM
Chancy Chancy is offline Keeping track of the original file when you copy/paste Windows 7 64bit Keeping track of the original file when you copy/paste Office 2010 64bit
Advanced Beginner
 
Join Date: Jan 2015
Posts: 32
Chancy is on a distinguished road
Default

In each source workbook (Workbook1, Workbook2), why not add this formula in a cell right above your sets of data, to identify the workbook for each set. Example:

In Cell A1 of Workbook1:
=cell("filename")

Then, in your summary file, link to Cell A1 in Workbook1, in order to pull that workbook's filename.

Do this for each set of data in your Summary.xls

This may not be the solution for you, though, as I did not understand this: "The missing element for me would be to have in the summary workbook a column that display the file name display in that fx area so I don't have to look up every cell to double check if I actually paste the right thing at the right place."

If what I suggested DOES work for you, then the caution is, using a link to a cell like this can be vulnerable to typos. You might copy data from Workbook2 into your summary.xls, but then accidentally grab a link to a different set of data in Workbook1.
Reply With Quote
  #3  
Old 09-01-2015, 02:11 PM
sidbisk sidbisk is offline Keeping track of the original file when you copy/paste Windows 7 32bit Keeping track of the original file when you copy/paste Office 2010 32bit
Novice
Keeping track of the original file when you copy/paste
 
Join Date: Aug 2015
Posts: 2
sidbisk is on a distinguished road
Default

Good Idea, I will keep that in mind for the future, now I found my solution with =formulatext

It work great and directly on excel 2013 and I had to create the function in 2010. Should work for previous too according to my reference

https://www.youtube.com/watch?v=wpRGTvhp1cY

Thanks anyway!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keeping track of the original file when you copy/paste Merging Word documents and keeping the formatting exactly as it appears in the original document NovaScotia Word 4 01-21-2015 11:44 PM
Keeping track of the original file when you copy/paste Keeping exact layout of source document when I copy and paste mjbowen147 Word 1 11-17-2013 02:08 PM
Keeping track of sent items Eugen_Denoes Outlook 8 10-22-2012 04:24 PM
Keeping track of the original file when you copy/paste Copy/Paste from Paint to Word - There is a problem saving the file one2three Word 1 10-26-2011 07:35 AM
Can no longer copy and paste an email file into a task kc300c Outlook 0 07-16-2010 04:34 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 06:01 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft