Forum Discussion
How to insert a row in worksheet A and have it auto populate in worksheet B
Good Morning, I have a workbook with two worksheets A & B. In A I have several rows of information to copy to worksheet B. I know how to use the = function to copy the rows from A to B but the...
Hi jessica-tls1
Attached is an alternate simple way that will will work with all versions of excel
It just uses INDEX and a row number to bring back the required rows
This is very helpful. Thank you so much!
If i could ask one other thing.
If I format B with grid lines or say bold text is there a way to make them show up when lines are inserted from A? The newly inserted lines don't recognize the formatting.
If i could ask one other thing.
If I format B with grid lines or say bold text is there a way to make them show up when lines are inserted from A? The newly inserted lines don't recognize the formatting.
With the Camera tool in place, follow these steps to use it:
- Select the cells or range of which you want a picture taken.
- Click on the Camera tool. The mouse pointer changes to a large plus sign.
- Change to a different worksheet.
- Click where you want the top left-hand corner of the picture to appear. The picture is inserted as a graphic on the worksheet.
- Also, is the intention to type any new data in on B that lines up with the values being pulled from A? If so my solution isn't ideal as if new rows are inserted (rather than added to the bottom) of sheet A then the typed in values on sheet B won't line up with the correct lines any more.
Does that make sense? - Any cells you format on B should keep that formatting when new lines are added to A. You may need to highlight and format more rows on B than are currently being "used" but then when new rows are added or inserted to A they will just show up formatted on B
