I have a form with a sub form within it....in the subform there is a that has a text box (titled HoursSum) that sums up a total number of hours.
In the form itself I have a text box that would show JUST the total hours......so basically my routine is I will chose crafts in the subform....plug how many hours for that particular craftsman....and at the bottom all the hours sum up to one grand total....once I have the grand total hours in the subform, I would then manually plug that number into a text box (titled Direct Hours) on the form....and that text box feeds a table.
I want to eliminate the manual plugging im doing and have that text box in the form automatically populate with the total that shows up in the subform.
I figured I could go in the Direct Hours text box in the form and put the following into the Default Value line in properties:
=[FCRDetail].[Form]![HoursSum]
but this does not work.
what am I doing wrong?
I have a streaming RTD feed coming in and I was wondering if there was a simple way to Sum the feed in a separate cell.
I was trying to use the Worksheet_Change event but that will not work with an RTD feed. The only other thing I could think of was to use the Worksheet_Calculate event but I can't seem to figure it out.
any help is greatly appreciated, thx.
can I have mrexcel feed on my website?
I have a cell (B4) that gets a live data feed. I would like something to run that logs the values from that B4 cell into another column every 2 minutes. I am still pretty green at using VBA so please keep that in mind. Thanks!
How do I create a msgbox with a line feed between lines ie
msgBox "welcome to this Spreadsheet. Hit ok to continue"
so the text show in 2 lines
Hello all,
First post here and also a new Excel user so please forgive me if I use incorrect terminology! Ok, so here goes. I'm trying to teach myself how to trade forex, and as part of my ongoing attempts to become profitable I am trying to analyse some of the price data in excel. I've managed to set up a live feed into Excel from my trading software using a DDE? Which works and is great but it just gives me current prices for the currency pairs and that's all.
So, my question is - Is there a way to take data from the live feed say, every hour, and form a table? Like a table that shows the prices for the last 24 hours and constantly updates itself? I'll leave it there for now and see if you guys and girls have any ideas. Thanks in advance,
Sam.
Hello agin! =)
Now, I really have a challenge..
In a sheet for calculating total feed given to fish,
I'm trying to accomplish a sheet that will calculate the total feed given, in witch cages they occur, and what brand they are.
the order of the feed and in what cages they are given will differ with the date.
Please see the attached sheet for a better understanding.
Regards, Andreas.,
I have two worksheets A, and B. On B I have columns A:J. I would like to copy and paste the rows from worksheet B where column J has a result greater than 0 to worksheet A. Please let me know if that makes sense.
Thank You
Tony
Is it possible or probable to have data from one MS Workbook "A" feed automatically to another MS Workbook "B"? I have a worksheet on workbook "B" that needs to be updated to the data in workbook "A".
I'm using MS Excel 2000 with Windows 98SE, if it matters.
Thank you for your help.
