AUTO FILL DATA BETWEEN SHEETS

Copper Contributor

I HAVE A WORKSHEET THAT CONTAINS ALL THE INFORMATION THAT I WOULD LIKE TO USE TO AUTOFILL ON ANOTHER SHEET. ANY ASSISTANCE IS APPRECIATED. IM A SELF TAUGHT EXCEL NEWBIE. THANX IN ADVANCE

1 Reply

@MzTeeRenee 

Fill data automatically in worksheet cells

Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.

More informations you will find in the upper link.

 

=[WorkbookX]'SheetY'!C3

WorkbookX and SpreadsheetY are to be replaced with their correct names.