Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 5/27/2006(UTC)
Posts: 135
|
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Huh?
Do "what" automatically?
wabbit [:D]
P.S. There isn't any reason to change the font weight and size; it doesn't get your post read any faster and it doesn't make people want to answer it any faster, some might even consider it the SAME AS SHOUTING!
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 5/27/2006(UTC)
Posts: 135
|
The data is
2/1/2011
11559.3
n1
2/2/2011
12174.6
n1
2/3/2011
12025.6
n1
2/4/2011
12475
n1
2/7/2011
12592.7
n1
2/8/2011
12316.3
n1
1/20/2011
12475
n2
1/21/2011
12592.7
n2
1/24/2011
12316.3
n2
1/25/2011
12448.5
n2
1/26/2011
12229.8
n2
1/27/2011
11559.3
n2
1/28/2011
12174.6
n2
1/31/2011
12025.6
n2
2/1/2011
12475
n2
2/2/2011
12592.7
n2
2/3/2011
12316.3
n2
2/4/2011
12448.5
n2
2/7/2011
12229.8
n2
2/8/2011
11924.6
n2
1/27/2011
11559.3
n3
1/28/2011
12174.6
n3
1/31/2011
12025.6
n3
2/1/2011
12475
n3
2/2/2011
12592.7
n3
2/3/2011
12316.3
n3
2/4/2011
11559.3
n3
2/7/2011
12174.6
n3
2/8/2011
12025.6
n3
Want to edit to below automatically
1/20/2011
12475
n2
1/21/2011
12592.7
n2
1/24/2011
12316.3
n2
1/25/2011
12448.5
n2
1/26/2011
12229.8
n2
1/27/2011
11559.3
n2
1/27/2011
11559.3
n3
1/28/2011
12174.6
n2
1/28/2011
12174.6
n3
1/31/2011
12025.6
n2
1/31/2011
12025.6
n3
2/1/2011
11559.3
n1
2/1/2011
12475
n2
2/1/2011
12475
n3
2/2/2011
12174.6
n1
2/2/2011
12592.7
n2
2/2/2011
12592.7
n3
2/3/2011
12025.6
n1
2/3/2011
12316.3
n2
2/3/2011
12316.3
n3
2/4/2011
12475
n1
2/4/2011
12448.5
n2
2/4/2011
11559.3
n3
2/7/2011
12592.7
n1
2/7/2011
12229.8
n2
2/7/2011
12174.6
n3
2/8/2011
12316.3
n1
2/8/2011
11924.6
n2
2/8/2011
12025.6
n3
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Although it MIGHT be possible to achieve using worksheet lookup functions, I think you'll get better results using VBA.
I'd sort the input data first by date, then progress through that sorted list adding the relevant data to the relevant column.
wabbit [:D]
P.S. No. I am NOT going to do this for you without you making a reasonable attempt of your own first.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 5/27/2006(UTC)
Posts: 135
|
Don't know about vba
Have try using lookup to edit the columns but is manually filling the columns rather autoly
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 5/27/2006(UTC)
Posts: 135
|
Wabbit do you have a vba for editing the data?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
I don't HAVE one, I'd have to write one.
wabbit [:D]
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
