my question is as follows hope to get some help
on sheet 2 of my work book in column C is project name
Column R is start date and Column S is end date
column s is duration of project
all i need to do is once each cell in each one of these columns is filled out manually i want it to be making a copy in the following columns on sheet 3
I need Column C from sheet 2 to automatically copy whats entered in next Column B next available Row in sheet 3
I need Column R from sheet to to automatically copy whats entered into column C next available Row in sheet 3
and I need column S from sheet 2 to automatically enter into column D of sheet 3
Sheet 1 is called ESTIMATES DATA SHEET
SHEET 2 is called WORK IN PROGRESS
sheet 3 is called Gantt chart
Bookmarks