Posts by Tom.Jones

Re: Making an Excel Stock Screener or Stock Tracker that grabs data from the Web?

Cross post

http://www.mrexcel.com/forum/e…acker-grabs-data-web.html

Re: Copy range with imputBox

Thank you S O,
I managed to do the copying, but I could not copy whenever needed. Now I have seen.

For i = 1 To xcopy
      myRange.Copy Destination: = Sheets (2) .Range ("A" & Sheets (2) .Rows.Count) .End (xlUp) .Offset (1, 0)
Next i

I knew how to do it. Perhaps my age ...
Once again Thank you.

Hi,

I need a little code to do the following:
1. ask me what range will be copied. I will select range.
2. ask me how many times to write this range in sheet 2
Selected range copy how many times is in question 2.
The data will be copied, one below the other, no matter how many times I run the code.
range in Sheet 1 and 2 is A:K and in row 1 has header
Thank You.

Re: copy folder from one location to another

Cross post

http://www.mrexcel.com/forum/e…ne-path-another-path.html

Re: Create sets of boxes

Million thanks, mikerickson.

Re: Create sets of boxes

I made it to rename sheets. Still workink to Total.

Re: Create sets of boxes

Thanks mikerickson,

Code does exactly what I asked but I have a small problem. Unable to change the code to call the newly created sheets Set1, Set2 ... SetN.
If possible, I would like in each sheet, to defend my weights sum to one row after the last row of the spreadsheet to appear Total xy, yz.
If you could help me.
Thank You.

Re: Create sets of boxes

mikerickson,

Thanks for your interest.

Do not select any box. The boxes will be taken in order from first to last and in this way will result in a variable number of sets, depending on the number of boxes. The rule is: Sum box weight is not more than 40 kg and the number of boxes not exceeding 20 boxes.
Ex. the first 12 boxes weight is say 38.58 Kg. These 12 boxes and their weight will be set1.
Let's say next 20 boxes (I'm not allowed to choose more than 20 boxes) weighing 28.5 kg. It will be set2.
Sheet2 will look like this:
set1 ...................... 38.58 Kg
set2 ...................... 28.50 Kg
...
setn ..................... xx, xy Kg

If I was not clear enough please tell and I'll try to explain better.
Thank you.

Hallo,

In Sheet1, column A, starting with A2 is box 1, box 2 box .... n. In column B have the weight of each box. The boxes have different weights.
In sheet 2, I would like to set up max 20 boxes but the total weight of no more than 40 Kg.

Or separate sheets for each part and set the sheet name to be set name.

Thank You.

Re: Userform to check 2 textboxes for duplicate & date check

It is not nice to post the same question in multiple forums. And if you have posted on several forums would normally have to know where you've posted.

Userform to check 2 textboxes for duplicate & date check

Re: Compare two cells and Highlight the difference with different colour.

jindon sama,

Excellent job.

Re: Automatic change date

OK. Thank you.

Re: Automatic change date

That's why I asked for your help as I could not solve this problem.

To activate the sheet to check if the date and month of that cell are the same as the current date, and increase by one year in that cell.
The event that triggers this to be either open or activate the worksheet file.

Re: Automatic change date

Need something like this:

Sub YearPlus()
Dim ac As Date
ac = ActiveCell.Value
If Year(ac) <> Year(Now()) Then ActiveCell.Value = CDate(Day(ac) & "." & Month(ac) & "." & Year(ac) + 1)
End Sub

But start automatic.
Thanks.

Re: Automatic change date

Thanks for the reply but I want, if I put in a cell (any cell) a certain date, that cell to be updated in exactly a year.

Ex. In B1 = 21.02.2001 - after just one year in the same cell to display 21.02.2002

Hello,

Intro cell put a certain date. How can I make just over one year this time to modify by increasing year by one.
Ex. I'm writing in a cell 25-11-1998 and the following year at the same time to have 25-11-1999.

Thank You.

Re: Index Match Formula using 3 criteria

Try this:

=if(iserror(index('POMes'!$D$2:$D$130000, MATCH(1, ('POMes'!$C$2:$C$130000 = '2014 PURCHASES'!H3)*('POMes'!$E$2:$E$130000='2014 PURCHASES'!M3)*('POMes'!$F$2:$F$130000='2014 PURCHASES'!S3), 0))), "",index('POMes'!$D$2:$D$130000, MATCH(1, ('POMes'!$C$2:$C$130000 = '2014 PURCHASES'!H3)*('POMes'!$E$2:$E$130000='2014 PURCHASES'!M3)*('POMes'!$F$2:$F$130000='2014 PURCHASES'!S3), 0)))

Re: Block cell to change after a certain time.

Thanks, both of you.

Re: Block cell to change after a certain time.

Thanks ashu1990

Unable to make the code work. In this file working after 14.00 (add new data always) and I would like to C3 cell can not be changed after 14:00, but to be able to enter data file. Worksheet_Activate but I tried did not work. Can you help me? Thank You.

Hello,

Please help me with the following problem.
In a password protected spreadsheet that can be accessed by multiple users (each accessing a certain range), we need the cell C3, can no longer be changed after 2 pm. How can I do that? Thank You.