Adding data to an existing spreadsheet

[clarkey10]

I'm thinking this is a simple thing to achieve but my limited knowledge of excel means I don't know where to start in order to do it!

I have a spreadsheet. Along the top the columns are named week 12 up to week 42 and down the side there are ref numbers - starting at approx 1000 and going up to 6500 (not all numbers are present though)

I receive data in the following format:
week no, ref no, data to input
eg. week 35, 4324, 179.

Basically I need to enter the number 179 into the correct cell in the spreadsheet.

Up to now I've been manually searching for the row & column and entering the number in the necessary cell. It struck me however that there must be a way I can enter the column, row & data info into a form & the data is automatically entered in the right cell.

Is this possible and how might I go about it please?!

Any guidance much appreciated.

I'm on a mac so not sure if the process is different but assume the terminology is the same?

Many thanks

[mehmetcik]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.


I need both your Main Spreadsheet and also your update data

The way to approach this is:

Open both sheets

convert your update data into a table in excel

Loop through each entry in the table

Use the match function to identify the column occupied by the Week No ( Unless this is easily mapped using a formula )
Use the match function to find the row corresponding to the reference,

If the weekNo or the reference don't exist then create them

Store the data in the correct position.

****************************************************************************************************

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[clarkey10]

Thank you.

Unfortunately the data I am entering is handwritten. but the spreadsheet I am filling in is attached (hopefully!)

I realise that filling out a form for each entry isn't going to save all that much time but figure it's got to be a better approach than searching for the right cell manually each time!

The data I received is written out and like this

Ref week Data
2456 23 345
3567 34 143


thanks x

[clarkey10]

Is anyone able to help with this?
Cheers