Exporting data from one .xls to another

[RichardOxon]

Hi there ...

My problem is that I am trying to export data from one .xls file to
another .xls file.

The two spreadsheets have the same number of columns and each field
contains the same data type in the same order - however the receiving
spreadsheet has macro dropdown boxes in it so it's not a case of simply
cutting and pasting unfortunately.

I'm sure there must be a way of assigning which data item on exporting
..xls refers to which item on dropdown box on receiving .xls - but it's
probably beyond my abilities as I have little programming knowledge.

To put this in context: I am entering wildlife survey data into a
spreadsheet on a PDA - this data then has to be given to a government
funding body in a certain spreadsheet they have designed to link in
with their computer systems (hence I can't simply give them my plain
old .xls sheet - even if it looks similar!). The only way to get round
this I see is to import my data into their spreadsheet.

Any help would be very much appreciated,

Best wishes,

Richard
Oxford, UK

 

[robert111]

create a new spreadsheet that pulls data from your spreadsheet. Format
it to the specified requirements, then e-mail it to them.

in spreadsheet 1, let A1 = 29.999

in spreadsheet 2, in A1 put =spreadsheet 1!$a$1

before you send it off, highlight all cells and then edit, copy, edit,
paste special, values

 

[RichardOxon]

Dear Robert, thanks for your input, but unfortunately it doesn't get
round the problem of the government wanting the data in the exact same
format in terms of the macro dropdown boxes. Effectively I want to
convert my xls fields into the 'official' dropdown phrases. I guess
this might involve 'telling' the spreadsheets what one value in my
field corresponds to what value in the other spreadsheet fields e.g. if
my spreadsheet says 'Grassland' it should convert to macro dropdown
option 'Grassland' in government .xls (not simply enter my data into
the box as 'plain' text'. The more I look into this the more
complicated it looks. It's so annoying they won't accept our own
spreadsheets! Many thanks, Rich.