R
rowanmk
Hi All,
I am looking to create a sheet where I can input data directly into the cell of sheet 1 (lets say for example, Date, Name, Date of Birth and Hair Color), click a button and it places the info into a table on sheet 2 and then the cells on sheet 1 go blank again.
I want this table on sheet 2 to be formatted as a table in Excel so lines are added to the "Range" and I can link graphs and tables based on this "source table".
Further, it would be awesome if the data can be put into a separate sheet based on the date (So all January birthdays appear in one table on Sheet 3 etc)...Not vital as this can be achieved through additional tables and Vlookups (maybe a messy way to deal with it).
Anyone able to help me with this?
Cheers
Rowan
I am looking to create a sheet where I can input data directly into the cell of sheet 1 (lets say for example, Date, Name, Date of Birth and Hair Color), click a button and it places the info into a table on sheet 2 and then the cells on sheet 1 go blank again.
I want this table on sheet 2 to be formatted as a table in Excel so lines are added to the "Range" and I can link graphs and tables based on this "source table".
Further, it would be awesome if the data can be put into a separate sheet based on the date (So all January birthdays appear in one table on Sheet 3 etc)...Not vital as this can be achieved through additional tables and Vlookups (maybe a messy way to deal with it).
Anyone able to help me with this?
Cheers
Rowan