Replies

sorry for the delay in replying, unfortunately i was unable to get your suggestion to work most likely because you had nothing to go off, other than my wording.
here is the solution i eventually worked out (i’ve included a copy of the file for you
1) copy route1 to route 2
2) copy and paste the following in I4
=sumif(‘#VALUE’!A:A,sheet1!A4,’#VALUE’E:E)
3) H4 copy and paste
=if(true=iserror(G4),I4,G4)
4) copy H:H & paste special paste as values in route1
it works though is still messy
thank you for your in put

sorry for the delay in replying, unfortunately i was unable to get your suggestion to work most likely because you had nothing to go off, other than my wording.
here is the solution i eventually worked out (i’ve included a copy of the file for you
1) copy route1 to route 2
2) copy and paste the following in I4
=sumif(‘#VALUE’!A:A,sheet1!A4,’#VALUE’E:E)
3) H4 copy and paste
=if(true=iserror(G4),I4,G4)
4) copy H:H & paste special paste as values in route1
it works though is still messy
thank you for your in put

it has a smell of success about it, look forward to tryng it tomorrow

it has a smell of success about it, look forward to tryng it tomorrow

i’mn sorry about this but a copy of the file i sent from work hasn’t fou nd its way to my pc at home , i will take a copy on a floppy or send from work

i’mn sorry about this but a copy of the file i sent from work hasn’t fou nd its way to my pc at home , i will take a copy on a floppy or send from work

thank you for your quick reponse to my call for help
either i’ve coppied the wrong files from work but sytill not working will try on friday—- on holiday until wednesday when i hope to reply further

thank you for your quick reponse to my call for help
either i’ve coppied the wrong files from work but sytill not working will try on friday—- on holiday until wednesday when i hope to reply further

with certain modifications to your text it now works a treat
1- Select Options from the tools menu and on the Calculation tab set calculations to Automatic.

1a- Insert an empty column between columns A and B.

2- Enter this formula into cell B2 (the new column).

=IF(ISTEXT(A2),A2,TEXT(A2,”0″))

3- Copy the formula down as far as the Component ID go in column A (hint: Double click on the cell B2 fill handle).

3A- f9 to update (calculate) (i prefer to have my settings at manual)
4- select all of column B (which is still selected from instructrion 3) and format as text
5- delete column A
finito works a treat
thank you very much for all your help

with certain modifications to your text it now works a treat
1- Select Options from the tools menu and on the Calculation tab set calculations to Automatic.

1a- Insert an empty column between columns A and B.

2- Enter this formula into cell B2 (the new column).

=IF(ISTEXT(A2),A2,TEXT(A2,”0″))

3- Copy the formula down as far as the Component ID go in column A (hint: Double click on the cell B2 fill handle).

3A- f9 to update (calculate) (i prefer to have my settings at manual)
4- select all of column B (which is still selected from instructrion 3) and format as text
5- delete column A
finito works a treat
thank you very much for all your help

sound very easy, will try at work tommorow, in 2 you say
2- Enter this formula into cell B2 (the new column).
i might off missed something here but what formula do yo mean?

sound very easy, will try at work tommorow, in 2 you say
2- Enter this formula into cell B2 (the new column).
i might off missed something here but what formula do yo mean?

the initial down load is a csv file and by changing the parameters for the date column from text to ” date ” (silly i know ) it now works the problem which persists is that column A dose not sort as you would expect.
what i have or hope to have is the same data but shown in two different ways, DATE order which i have overcome and COMPONENT order which is still a pain.
i have included a copy of the excel file

the initial down load is a csv file and by changing the parameters for the date column from text to ” date ” (silly i know ) it now works the problem which persists is that column A dose not sort as you would expect.
what i have or hope to have is the same data but shown in two different ways, DATE order which i have overcome and COMPONENT order which is still a pain.
i have included a copy of the excel file

thank you for your quick responses ,i will post a copy of the file tommorow