spread

I have a userform and I need for the user to enter the date in datepicker 1 which will then specify the computers time automatically in textbox 2. this time needs to then be locked and not change once in the spread sheet. any help would be greatly appreciated. I'm just learning thanks Wes

First of All Hi to All out there in MRExcel world.:biggrin: I am fairly new to excel and I have been tasked with a pig of a query, I need to automate a report in one spread sheet to draw data from certain cells on tabs in another spread sheet held on a server.basically the report has to show...

Trying to get 4 dining rooms with 4 tables set up to work in a pie chart I need a function that can move a client from 1 dining room to another and to a different seat.Can some one help with this pleaseÉ Also I have managed to get 1 pie chart working I saved in 4 different work books (clearly...

Hello all, I hope you can help me. I have a spread sheet set up and I record when documents are returned to me. When I put the word "returned" in a cell , I'd like the date the document was received to be posted into the adjacent cell on the spread sheet. Thanks MR VEB

Hello i have a macro where i have information in columns A, B, E, and F. Columns A & B are being pulled in from one spread sheet and columns E and F are being pulled in from another spreadsheet. I would like to combine columns E and A into column A and get rid of duplicates. After this being...

Hi! So I have an existing worksheet that calculates SLD in a way that is somewhat manual. The columns are the years 2017-2027 onward and the life of the asset. The rows are: <tbody> Life 2017>>2027 (each column is a year) Asset 1 5 For each year is the asset purchase amount Asset 2 3...

Hello, I am trying to build an amortization schedule that will spread an amount equally over a specific number of months per line item. I am trying to find when the first month of the spread occurs and then simply replicate the amount for the remained of the term. The values before the match...

Hi there, this has been driving me crazy. I receive raw data and I'm trying to sort it for inventory purposes; the cell looks like this: <colgroup><col></colgroup><tbody> 08/24 Shifts: 08am-11am (30 projected) </tbody> I am looking to extract the number after the parenthesis and it's...

Hello! I have a set of data similar to the following plotted as two line graphs, one for Bills, one for Coups. As any point between the two lines, I would like to find the difference. The problem is, the data points do not line up, so I can't simply take Coups minus Bills. Is there a way to...

I have a workbook with products and services spec sheets and a summary sheet. On the summary sheet, each line correspond to a product. I am trying to make projections of human resources used each month in function of units sold. On any given spec sheet, there is a table which lists the...

Afternoon all and hope I find you well. I have created a working sheet, but the management and user-friendliness are around 1 out of 10. I am usually able to get cells to do what I need, but not in a space saving, tidy way and wondered if there is a simple solution to what I try to update...

I have a spead sheet, showing the contractor costs involved in a project and another showing the building costs. For example: lets say I have data to say that the contracting costs are always 25% of the building costs, and that the (contractor) spend will occur the year before building...