Calling experienced excel users

[cluaindiuic]

Copy an paste a few times and then sort?

[Big_Dan_Campbell]

@Julio Geordio

FFS Chewy you need to do an excel course for beginners.
Do you know how to insert rows?
If so insert two rows under aaaa and drag down the top row so that its copied in all of them.
Repeat for the rest and pray to god they never ask you to do something difficult.

There is a 1000+ values, no way am i going doing that

[Big_Dan_Campbell]

@cluaindiuic

Copy an paste a few times and then sort?

[cluaindiuic]

@chewy louie

I told the boss it was a 5 minute job and here I am 6 and a half hours later, please advise runt

Genuine :lol:

[The_Runt]

@chewy louie

I told the boss it was a 5 minute job and here I am 6 and a half hours later, please advise runt

:lol:

I’d say CLD has you sorted.

[Julio_Geordio]

@chewy louie

There is a 1000+ values, no way am i going doing that

:lol:

It doesn’t matter how many values there are you tit. You just highlight the row and drag down on the bottom corner of the last cell.
Its essentially copy & paste but faster.

[fenwaypark]

@chewy louie

I told the boss it was a 5 minute job and here I am 6 and a half hours later, please advise runt

[Julio_Geordio]

@chewy louie

I told the boss it was a 5 minute job and here I am 6 and a half hours later, please advise runt

:lol:

I hope you don’t actually have to do anything with the data or you could be writing off a week.

[cluaindiuic]

Also if you select one cell and copy it, then select a few cells and paste it, it pastes in the single copied cell into multiple cells.

[cluaindiuic]

DP

[Julio_Geordio]

@cluaindiuic

Also if you select one cell and copy it, then select a few cells and paste it pastes in the single copied cells into multiple cells.

Baby steps CLD, baby steps

[The_Runt]

Fuck em Puke.
It takes a bigger man to ask for help.
Never be afraid to call your local IT guy, we’re here to help and make your life easier.

[Big_Dan_Campbell]

@The Runt

Fuck em Puke.
It takes a bigger man to ask for help.
Never be afraid to call your local IT guy, we’re here to help and make your life easier.

I have no problem turning to the good people of TFK for my excel needs

Thanks to you and CLD for your positive input

[Julio_Geordio]

=If(knowledge of excel<0, take a beginners course, take no action)

All joking aside Puke you should do an excel course for beginners. Being able to use excel will make your life a lot easier. The little tricks and shortcuts could (literally in your case) take hours off the work your doing.

[Big_Dan_Campbell]

@Julio Geordio

=If(knowledge of excel<0, take a beginners course, take no action)

All joking aside Puke you should do an excel course for beginners. Being able to use excel will make your life a lot easier. The little tricks and shortcuts could (literally in your case) takes hours off the work your doing.

Have little or no use for it and with the likes of CLD and Runt on here I don’t need to learn it, i will continue to delegate my excel needs. Thanks for your feedback

If you have any more questions or queries please let me know

Kind Regards

Chewy Louie

[Big_Dan_Campbell]

dp

[cluaindiuic]

This is true. I only really know the basics.
But I don’t use Excel much day to day.

[Special_Olympiakos]

I have literally 100’s of rows with amounts in them.

I’m then given a total amount and told to highlight in the rows what individual amounts make up the total.

Anyway of doing this without going through every record and combination of amounts, manually?

[cluaindiuic]

I think we have to cut him off Runty

[Julio_Geordio]

@Special Olympiakos

I have literally 100’s of rows with amounts in them.

I’m then given a total amount and told to highlight in the rows what individual amounts make up the total.

Anyway of doing this without going through every record and combination of amounts, manually?

I’ve no idea what your trying to do here

If you’ve totaled them then they all make up the total no?