Help MSB (microsoft visual basic) code for an Excel Macro button
Closed
kristiyanstoychev
Posts
1
Registration date
Tuesday August 18, 2015
Status
Member
Last seen
August 18, 2015
-
Aug 18, 2015 at 04:37 AM
RayH - Aug 20, 2015 at 01:27 PM
RayH - Aug 20, 2015 at 01:27 PM
Related:
- Help MSB (microsoft visual basic) code for an Excel Macro button
- Battery reset code - Guide
- Samsung volume increase code - Guide
- Usa country code for whatsapp - Guide
- At button - Guide
- Microsoft excel download - Download - Spreadsheets
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Aug 18, 2015 at 11:56 AM
Aug 18, 2015 at 11:56 AM
Hi kristiyanstoychev,
Could you upload your file without any sensitive information to a free file sharing site like www.speedyshare.com or ge.tt and then post back the download link, for better understanding of your query?
Best regards,
Trowa
Could you upload your file without any sensitive information to a free file sharing site like www.speedyshare.com or ge.tt and then post back the download link, for better understanding of your query?
Best regards,
Trowa
I had bit of fun with this:
Paste this into the "How Many?" field B7
In order for this to work the references for AGE have to be the same in all instances. They were different in your sample. That is to say that the Validations need to match what is in the Company tabs.
=OFFSET(INDIRECT($B$3 &"!A1",TRUE),MATCH(Input!$B$4,INDIRECT($B$3 &"!A:A",TRUE),0)+MATCH($B$6,INDIRECT($B$3&"!A"&MATCH(Input!$B$4,INDIRECT($B$3 &"!A:A",TRUE),0)+2&":A"&MATCH(Input!$B$4,INDIRECT($B$3 &"!A:A",TRUE),0)+5,TRUE),0),MATCH($B$5,INDIRECT($B$3 &"!B" & MATCH(Input!$B$4,INDIRECT($B$3 &"!A:A",TRUE),0)+1 & ":D" & MATCH(Input!$B$4,INDIRECT($B$3 &"!A:A",TRUE),0)+1,TRUE),0))
Paste this into the "How Many?" field B7
In order for this to work the references for AGE have to be the same in all instances. They were different in your sample. That is to say that the Validations need to match what is in the Company tabs.
that seems helpful. In this way I can take a value from a table and show it in a cell. What I want to do though, is take that value from the cell and write it in a specific place in the table.
Example - you have a table (A1:B5) with empty cells. With this function I need to take the value from cell H10 and write it in (A3, which would be determined by those offsets)
Do you know the function for this mate?
Thanks
Example - you have a table (A1:B5) with empty cells. With this function I need to take the value from cell H10 and write it in (A3, which would be determined by those offsets)
Do you know the function for this mate?
Thanks
Aug 19, 2015 at 02:38 AM
https://www.dropbox.com/s/1wzed9nzhsw0amf/Sample.xlsx?dl=0
It is obviously simplified but this will be enough to show me the code that I need to write for my job. Thank you.