pick

I have the following simple Macro. The problem is now I want the user to pick which Sheet they want to paste the information on. I have Account_1, Account_2, Account_3, etc. tabs and there may be more the user adds so it is never going to be predetermined. I would like for the user to pick...

Hello All, This is my first of likely many questions on this forum, as my excel skills are far too basic for my liking and I am keen to better them. I am given a task where I have a row of various different addresses for head offices of public companies. I just need the US state of where they...

Trying to create a spreadsheet where the user can pick a Machine from one cell, then pick the Material to run in the machine from another cell and based on those 2 inputs the cost per Kg is shown in another cell. The idea is to use drop down menus for the selections. Is that possible to use Data...

Hello dear MrExcel! Indirect values from sheet1, but it needs to skip 3 rows, pattern is always 3 rows, and there will always be 2 rows to pick up;) Thanks in advance! [/IMG] [/IMG]

I'm trying to do a quick excel sim of the monty hall problem. I've used RANDBETWEEN(1,3) in columns B and and F for the initial guess and the actual winning door however I need to determine which door is opened. Basically my question is how do I make excel do my title, pick a random number...

I am trying to do my own and personal lottery analysis. One of the things I have is four sections of 6 columns each, 11 rows down. All these filled with different and reapeated numbers from 1 to 60. What I want, is to have Excel pick out the repeated numbers and give me a count of those. I have...

Hi guys, I want to know how to pick values to a certain cell. For example this one: <TABLE style="WIDTH: 1343pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1790><COLGROUP><COL style="WIDTH: 1343pt; mso-width-source: userset; mso-width-alt: 65462"...