@MyCon
More importantly, what's the solution?...it may be important to you but not to the members who give their time for free and will offer help, if they can and when they have the time.
In stead of demanding a solution you should read the forum rules where you would come across this...
Enter your data in the main sheet, go to the sheet where you want to paste/copy. Select the cell where you want to place the copied data and in the formula bar insert the equals sigh, click on the sheet tab of your main data select the cell with data and press enter. Done
If you had taken just a moment to read the forum rules you would have read this bit,
Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out.
Cross-Posting. Generally, it is considered poor...
If you had taken just a moment to read the forum rules you would have read this bit,
Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out.
Cross-Posting. Generally, it is considered poor...
I am sure that there will be members who think I have been curt and abrupt but if posters just took a moment to gather their thoughts as to what they need from forum members they would be able to formulate a post title that would attract the right help. And with members giving their time for...
...26as... As a post title this must be in the lead for the worst most non-descriptive title ever, if you had bothered to read the forum rules you would have read this:-
How to get the Best Results at Chandoo.org
Use Relevant words in the Title and in the tag Box, This will aid future...
If you bothered to read the site rules you would have read this:-
email address. Spam robots do trawl forums collecting this info.
Abusive language will not be tolerated.
Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members...
....What options do I have ?....Very few. Excel was never designed to do what you want, users editing at the same time!! heart ache will ensue.
Why do you need others to mess around with the pivot tables? For them to be able to enter data in to the raw data table should be enough and only by an...
Excel has more ways to skin a cat than needed, but the choices are there for the users, why restrict the options the only thing that should be consigned to the waste bin is the merge option.
If you think your problem is so important that you need to post on multiple forums then have the decency and manners to inform members of your actions, members are going to give their time for free to help you when you may have already received an answer on another forum, wasting their time...
There are many differences between Excel and Open Office just altering the file extension does not mean one will work with a different set of trousers on.
Avoid merging cells
Merged cells can help you arrange values in a meaningful way, but they come with problems -- numerous problems, big problems.
For instance, Excel won't apply column formats to a merged cell unless you select all the columns that comprise the merge.
In addition, not all...