Excel 2010

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:29 PM GMT

Question

Hi Aidan,I was wondering whether there is a spreadsheet or macro that allows me to change data on 1 sheet and it reflects that change into a datawarehouse sheet. I'm looking to almsot create a forum type of sheet where my reps can just have a look at there individual region rather then having access to mulitple regions. Was having a hard to get started on this so any help/guidence would be appreciated. Vish

Answer

It would be possible, though I've not really got enough to go on - it is POSSIBLY an array filter where data for choices can be set on a second page - http://aidanheritage.byethost3.com/excel/Array_Filter.xls has an example of this - let me know if I can help further - if it helps my email is aidan.heritage@virgin.net

Question

I have a column of numbers 10050 - 10099. I want to click on any number in the column and have it show up in one particular cell. This is a list of work orders and as I create a new work order I only want to click on the next available number and have it change the number in the work order

Answer

The only way I can think of to do this would be via vba - for which, see http://www.aidanheritage.byethost3.com/excel/invoice.xls for an example method. Please let me know if I can help further - I'm away for a while, but my email is aidan.heritage@virgin.net

Question

i am using2010 on my laptop. All spreadsheets i receive via e-mail were created in earlier versions. when i open them it launches2010, however, nothing appears on the screen justopen with no worksheet to review

Answer

When there is no any otherwindow and when you are attempting to open the file will initially force theapplication to open and keeps the blankwindow in front of you. Without closing the blankapplication click the file once again and now it will show the content of the file. It will not happen in all the cases but sometime it will happen.

Advertisement

©2021 eLuminary LLC. All rights reserved.