# Search:

Type: Posts; User: TheRins3r; Keyword(s):

1. ## Thread: Updating a status

by TheRins3r
Replies
1
Views
86

### Updating a status

Looking for help with the below....

Basically,

I want to track the status of an item.

If i am to enter a date lets say in column C which is titled " Item setup date" i would like the...
2. ## Thread: Weeknum

by TheRins3r
Replies
8
Views
175

### Re: Weeknum

Your formula works, i forgot to change the lookup cells when i pasted it in!!

Thanks very much.
3. ## Thread: Weeknum

by TheRins3r
Replies
8
Views
175

### Re: Weeknum

yes , it is a date.
4. ## Thread: Weeknum

by TheRins3r
Replies
8
Views
175

### Re: Weeknum

Unfortunately that did not work, see below example where the new week count starts at 0 and should start at 1

<tbody>
28/06/2019
28-Jun-19
2019
JUN Qtr
June
13
5. ## Thread: Weeknum

by TheRins3r
Replies
8
Views
175

### Weeknum

I have a formula below , where I need the week number from 1 - 13 depending on the upload date & what Qtr we are in.

=WEEKNUM(J4058)-WEEKNUM(LOOKUP(J4058,DATE(YEAR(J4058),{3,6,9,12},30)))

...
6. ## Thread: Concatanation problem

by TheRins3r
Replies
8
Views
159

### Re: Concatanation problem

That worked perfectly Jeff, Thanks a lot.
7. ## Thread: Concatanation problem

by TheRins3r
Replies
8
Views
159

### Re: Concatanation problem

Thanks Jeff,

That almost worked, apolgies.

The data which i need from A, needs to be added into B ( and replace/delete the following "XXXXXXXXXXXXXXXXXXXXXXXXX".
It also added a space before...
8. ## Thread: Concatanation problem

by TheRins3r
Replies
8
Views
159

### Re: Concatanation problem

It needs to be placed as the 49th character in a string of text that totals 104.
9. ## Thread: Concatanation problem

by TheRins3r
Replies
8
Views
159

### Re: Concatanation problem

Hi Jeff, Thanks for your help.

Basically i have 30k lines i need to do this for, i need to copy text from column A "TEXT1" and paste it into column B.
I want to keep what is in B and add the data...
10. ## Thread: Concatanation problem

by TheRins3r
Replies
8
Views
159

### Concatanation problem

Hi All,

I am looking to take data from column A and paste it into column B.
However, i need to paste it into the middle of a string of text that lies in B.

Help would be much appreciated.
11. ## Thread: Creating an IF statement

by TheRins3r
Replies
2
Views
113

### Re: Creating an IF statement

<tbody>
Overall Status
Data A
Data B
Data C
Data D

Ready / Testing / Production etc
When i enter Data here, i want the "Overall status" to update.
12. ## Thread: Creating an IF statement

by TheRins3r
Replies
2
Views
113

### Creating an IF statement

Hi Folks,

Hope you can help me.

I have created a log, where i populate daily with certain data.
What i am ltrying to achieve is, when i enter data into column D letys say, it automatically...
13. ## Thread: MsgBox prompt

by TheRins3r
Replies
3
Views
138

### Re: MsgBox prompt

thanks a lot, they both worked :)
14. ## Thread: MsgBox prompt

by TheRins3r
Replies
3
Views
138

### MsgBox prompt

Hi,

I am looking to add a MsgBox with Yes/No prompt, below is how far i have got.

Answer = MsgBox("Have you set Bla Bla to Active?", vbYesNo)
If Answer = vbYes Then

Else If Answer = vbNo...
Results 1 to 14 of 14