Excel VB code help required ...

Jed Shields

Jed Shields

Jed Shields

Associate
Joined
23 Apr 2007
Posts
1,785
Location
Cardiff-ish, Wales
Hi guys,

I'm looking to input some text in a cell, and for it to be copied into a table on another sheet (SHEET TABLE), based on a Row and Column identifier that is selected using dropdown lists.

So, for example, I want to type in the text, then select Product 1 from the first list and Week 1 from the second list. I then hit a macro button and the value I've typed in goes to the SHEET TABLE, Cell B2, assuming that's where Product 1 and Week 1 intersect. And assuming Product along Columns, Weeks down Rows.

Then I could delete the text, type something else in, select Product 2, Week 1, hit the button and it would copy the text to SHEET TABLE Cell B3 etc.

Does that make sense?
 
Not sure you need to do this in vba, sounds like this can be accomplished with index and match but it's pretty hard to know what you need without an example.
 
I think you got some thing wrong in your description.
If Product along Columns, Weeks down Rows, and if you select Prduct1 : Week1 gets Cell B2, then when you select Product2 : Week1, shouldn't it go to Cell C2 right?

Or have I got it wrong?
 
Avathar77 said:
Do you see the "User's Trust" link in the bottom of one of my posts?
Click on that and another popup window will open. Now click on "Click here to send a message" and just type.
Click to expand...

Ahhh, I can't access it as I've forgotten my password. I've emailed Admin for a reset but haven't had a reply yet.

Tell you what, copy my business email: [email protected]

And yes you're right, it should be C2 ...
 
ok, eating now will send it tonight! :)

Edit : wait, how did you post a thread with out a password? unless it is on "remember password"?
 
You must log in or register to reply here.
Back
Top Bottom