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
