98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » MS EXCEL
MS EXCEL
Resolved · Medium Priority · Version 365
Krystian has attended:
Project Introduction course
Project Intermediate course
MS EXCEL
Hi,
My question relates to Excel - feeding data from one sheet to another in same workbook (file).
Basically, my sheet1 contains list of product number, product describtion and it's price.
In sheet2, I want all the data from sheet1 to feed into sheet2 automatically which is quite simple by using "=" sign and selecting the relative cell.
However, how do I feed the data from sheet1 into sheet2 if I have inserted a new row in sheet1? What script do I need to write to feed any new inserted row into sheet2.
Thanks
RE: MS EXCEL
If it helps, please tell me how to attach the excel file so, I can attach my spreadsheet.
Thanks
RE: MS EXCEL
Hi Krystian
Thanks for your question, it's a good one.
Unfortunately, using your method of linking data it's not possible to have sheet 2 automatically update when you insert a row into sheet 1. The only way would be to manually go in and insert a row and update the cell references accordingly.
Regards,
Sarah
Excel Trainer
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create own ribbon tab - Excel 2010a. In Excel click on the File tab |