|
Automatic Copy of Data
I have spreadsheet A and spreadsheet B. I update A each day and need to
copy that info to B as well. I set up a link from A to B and it worked fine. My problem is that A gets updated each day in a new set of cells so the link from the previous day no longer works. I was thinking it might also work if I can update A and have Excel, at the same time, automatically copy my update to a 2nd set of cells in A. I can then link this 2nd set of cells to B and get the info Im looking for. Each day the 2nd set of cells would get written over with the current data and update the cell in B. Im trying to eliminate manual copy and paste if I can. Any help would be appreciated. Thanks. -- Rags |
Why don't you fill all cells in sheet B with the links to sheet A ?
Regards, Stefi €˛Rags€¯ ezt Ć*rta: I have spreadsheet A and spreadsheet B. I update A each day and need to copy that info to B as well. I set up a link from A to B and it worked fine. My problem is that A gets updated each day in a new set of cells so the link from the previous day no longer works. I was thinking it might also work if I can update A and have Excel, at the same time, automatically copy my update to a 2nd set of cells in A. I can then link this 2nd set of cells to B and get the info Im looking for. Each day the 2nd set of cells would get written over with the current data and update the cell in B. Im trying to eliminate manual copy and paste if I can. Any help would be appreciated. Thanks. -- Rags |
Sheet B has only 1 column of cells that gets updated with each new day info.
It gets overwritten each day by the new info from the next column of cells in Sheet A. -- Rags "Stefi" wrote: Why don't you fill all cells in sheet B with the links to sheet A ? Regards, Stefi €˛Rags€¯ ezt Ć*rta: I have spreadsheet A and spreadsheet B. I update A each day and need to copy that info to B as well. I set up a link from A to B and it worked fine. My problem is that A gets updated each day in a new set of cells so the link from the previous day no longer works. I was thinking it might also work if I can update A and have Excel, at the same time, automatically copy my update to a 2nd set of cells in A. I can then link this 2nd set of cells to B and get the info Im looking for. Each day the 2nd set of cells would get written over with the current data and update the cell in B. Im trying to eliminate manual copy and paste if I can. Any help would be appreciated. Thanks. -- Rags |
Is there a column in sheet A containing the date of the new day from which
Excel can identify rows to be copied to sheet B? Stefi €˛Rags€¯ ezt Ć*rta: Sheet B has only 1 column of cells that gets updated with each new day info. It gets overwritten each day by the new info from the next column of cells in Sheet A. -- Rags "Stefi" wrote: Why don't you fill all cells in sheet B with the links to sheet A ? Regards, Stefi €˛Rags€¯ ezt Ć*rta: I have spreadsheet A and spreadsheet B. I update A each day and need to copy that info to B as well. I set up a link from A to B and it worked fine. My problem is that A gets updated each day in a new set of cells so the link from the previous day no longer works. I was thinking it might also work if I can update A and have Excel, at the same time, automatically copy my update to a 2nd set of cells in A. I can then link this 2nd set of cells to B and get the info Im looking for. Each day the 2nd set of cells would get written over with the current data and update the cell in B. Im trying to eliminate manual copy and paste if I can. Any help would be appreciated. Thanks. -- Rags |
Row 2 in each column of Sheet A contains the calendar date for that
particular day. Is that what you mean? -- Rags "Stefi" wrote: Is there a column in sheet A containing the date of the new day from which Excel can identify rows to be copied to sheet B? Stefi €˛Rags€¯ ezt Ć*rta: Sheet B has only 1 column of cells that gets updated with each new day info. It gets overwritten each day by the new info from the next column of cells in Sheet A. -- Rags "Stefi" wrote: Why don't you fill all cells in sheet B with the links to sheet A ? Regards, Stefi €˛Rags€¯ ezt Ć*rta: I have spreadsheet A and spreadsheet B. I update A each day and need to copy that info to B as well. I set up a link from A to B and it worked fine. My problem is that A gets updated each day in a new set of cells so the link from the previous day no longer works. I was thinking it might also work if I can update A and have Excel, at the same time, automatically copy my update to a 2nd set of cells in A. I can then link this 2nd set of cells to B and get the info Im looking for. Each day the 2nd set of cells would get written over with the current data and update the cell in B. Im trying to eliminate manual copy and paste if I can. Any help would be appreciated. Thanks. -- Rags |
Assume the column to be updated in sheet A is column A. Enter this formula in A1 in sheet B =INDIRECT(ADDRESS(ROW(A1);MATCH(TODAY();SheetA!$2: $2;0);4;;"SheetA")) It will show the column of sheet A the date of which is todays date. Regards, Stefi €˛Rags€¯ ezt Ć*rta: Row 2 in each column of Sheet A contains the calendar date for that particular day. Is that what you mean? -- Rags "Stefi" wrote: Is there a column in sheet A containing the date of the new day from which Excel can identify rows to be copied to sheet B? Stefi €˛Rags€¯ ezt Ć*rta: Sheet B has only 1 column of cells that gets updated with each new day info. It gets overwritten each day by the new info from the next column of cells in Sheet A. -- Rags "Stefi" wrote: Why don't you fill all cells in sheet B with the links to sheet A ? Regards, Stefi €˛Rags€¯ ezt Ć*rta: I have spreadsheet A and spreadsheet B. I update A each day and need to copy that info to B as well. I set up a link from A to B and it worked fine. My problem is that A gets updated each day in a new set of cells so the link from the previous day no longer works. I was thinking it might also work if I can update A and have Excel, at the same time, automatically copy my update to a 2nd set of cells in A. I can then link this 2nd set of cells to B and get the info Im looking for. Each day the 2nd set of cells would get written over with the current data and update the cell in B. Im trying to eliminate manual copy and paste if I can. Any help would be appreciated. Thanks. -- Rags |
I forgot to tell that fill it down in as many rows as you have!
Stefi |
Sorry, this sentence is wrong:
Assume the column to be updated in sheet A is column A. The right one: Assume you want to see the replicate of the latest column in sheet A in column A in Sheet B. |
Worked okay after some trial and error. Thank you very much.
-- Rags "Stefi" wrote: Sorry, this sentence is wrong: Assume the column to be updated in sheet A is column A. The right one: Assume you want to see the replicate of the latest column in sheet A in column A in Sheet B. |
| All times are GMT +1. The time now is 12:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com