Hello,
I have been looking through the posts to see if I could find help with my problem but since I am a self taught Excel user, I wasnt really sure of what to look for.
Here is the problem I am trying to figure out:
I have a large spreadsheet that I built for some people where I work to help them forcast generator loads through the day. On the first tab there are 2 columns for each generator we have and there are rows for each hour (Ill call it Table A). The first column is the forcasted minimum load and the second column is for the forcasted maximum load. There are 4 generators that they enter data for. The calculator does a lot of calculations and breaks the data down into numbers that they copy and paste into a form that we submit to an agency. Some of the operators have asked me to come up with a way where they could come up with a total min and max load for all of the units and enter that data into a table (Ill call it Table B)and have the calculator populate the Table A that has the individual units.
Since there are times we would have to use Table A and only some of the operators want to have the Table B, I thought I would create an option button to select which way data is entered. If Option Button one is selected, data would be entered into Table A as normal. If Option Button 2 is selected, data would be entered into Table B. I have most of the items built including the functions to take the total min and max values entered in Table B and breaks the data down into individual loads. The problem I am having is how do i take this data for the individual units and copy it to the proper cell in Table A? The basic problem is I need the ability to manually enter data in Table A or to have the program write data to Table A if that option is selected.
I am sorry this is so lengthy and it may not be able to even be done without more extensive programming but I thought maybe someone may now a way of moving data from one cell to another.
TIA!
Hi,
Is there any way to enter a formula to denote the last business date?
Thanks
Easy scroll to down ways, should I copy rows to a column?
Please see the attachment for a more clearance.
Excel 2003. I had this working years ago but have since forgotten how to do this.
I need to start Excel 2003 two different ways depending on one of two short cuts used. In one case, I want to start Excel 2003 and automatically load files in the start-up folder. In the other case, I want to start Excel 2003 but not load any workbooks automatically. Any help would be appreciated. Thanks.
Guys,
I am new to the forum. There is alot of valuable information here. Anyways I would like to ask for your opinion if this can be done. I have a excel workbook with customers names, email address, SR and RMA numbers, Part that was shipped and qty. It also contains when it was shipped. This sheet has decent amount of data in it. What I would like to do is email the outstanding parts that have not been shipped back from excel that contains a message to the customer and with the parts below that need to be returned. I would like it to update a ticker in excel that once I have hit the send button 3 times then the button is greyed out. Can this be done? I have already seen a vba macro that sends the rows out to outlook but I want it to contain all the customers outstanding parts instead of sending a email for each one. If someone can help me I have the form to show you.
Regards
Corey
Hi,
Can someone please tell me all the different ways in which an Excel Workbook can be shared for multiple users to edit?
Thanks.
Dan
Hi,
Can someone please tell me all the different ways in which an Excel Workbook can be shared for multiple users to edit?
Thanks.
Dan
My business users dont know access at all so I need a easy way for them to import excel sheet to specific tables.
Planing to develop this functionality in one of the 2 ways
Design 1 -
I plan to have a a separate button for each file type. When a user press this button a small window should pop-up asking user to browse the file to import. Once user browse and selects the file, he press the import button which should trigger a query to append this data to an existing table.
Design 2 -
Similar to design 1 but instead of user browsing to search the file, there will be specific folders on C: for each file type where the user will put these files. then on the form all user has to do is hit the import button to import this data.
Please advice how to develop these designs.
Thanks
SKV
Can i set auto recovery for Excel?
Thanks in advance
...this is a bit of an unusual post I suppose. I am curious if anyone has had any luck with outsourcing NON-COMPLICATED Excel work and if they had tips or advice on how to go about it.
I have an Excel file with over 300 tabs of report data that I am looking to make a database out of. I want to hire someone (I was thinking of using elance.com) but it isn't very sophisticated work. It would mostly be formatting grunt work.
Thanks for any suggestions or advice!
Kind regards,
Jake
