How do you use excel as a database
How do you use excel as a database
Last edited by NPM2; 11-22-2009 at 07:22 PM.
Hi,
there are several ways to approach this.
If you want a duplicate of the sheet, click cell A1 in the new sheet and enter
=Sheet1!A1
then copy down and across. This assumes that the source sheet is called Sheet1, you need to change the sheet name in the formula if it isn't
If your other sheet should have a different layout from the original sheet, it might be best to post a workbook with some sample data in your desired layout and describe what you want to achieve.
You can upload a file by clicking "Go Advanced" below and then the paper clip icon.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks