Any advice/ help please
Downloaded and copied BA multiple spreadsheet.
Is there a way to copy and paste Column L to Column AE and put in same spreadsheet maybe 2 or 3 times.
ie after first AE column L-AE, then after 2nd columns L-AE etc
Basically eg I have 3 x multiple (50+)spreadsheets with different criteria so 150 total open at same time.
Would only need 50 open and not 150.
Prob Shaun will answer
BA Multiple Excel Sheet
Go to the cell yopu want to copy to (AE10)
type in the = (do not press enter)
go to the cell you want to copy (L10)
Now hit enter and this should show the value in that is in L10 in AE10
May I make a suggestion, udemy.com is a great site to learn almost anything for a very small price. They have great excel courses for about $15 aussie. You get the course for life and they are all very well done. Highly recommend it.
type in the = (do not press enter)
go to the cell you want to copy (L10)
Now hit enter and this should show the value in that is in L10 in AE10
May I make a suggestion, udemy.com is a great site to learn almost anything for a very small price. They have great excel courses for about $15 aussie. You get the course for life and they are all very well done. Highly recommend it.