info

I've found a things, but I can't piece this together. From tab 1, I need to find and item on tab 2, move 1 cell left, and up to the next cell with data. First Tab: (the small blue info is what I want to pull from tab two) <tbody> Name Number Description other 77-dept 11 ...

Hi everybody, I use this forum as much as I can to look for better ways to use Excel, but I'mn ot that good with VBA and I need ome help for restructuring some finance data into a Database tab. I have 4 tabs, identical formatting except the amounts per Month are different. The 4 tabs represent...

What would be the best formula to use if column B matches something in column X, populate adjacent info in cell Y in column P in same row as column B.

Hi, I was wondering about copying what's hidden on one sheet to another sheet. If I hide columns/rows as hidden data, can I copy the info as hidden to another sheet and still unhide the info inside the new sheet? Thanks, Studt#37

Hi, I presently have coding that is fulfilling all my requirements except for the ability to save in a back up workbook. The back up workbook is located at (M:\HR\National Transfer Inventory\xxxx National Transfer Inventory Referral.XLSM) this is my present code: Private Sub...

In my Excel 2016 form, I seem to have a disappearing border. I have columns of info that are completed using the drop down box and data validation. If I make a selection and use the auto fill, my upper and lower borders in the cells disappear. It then becomes a continuous column of info...

Hello, I need help with a spreadsheet I'm working on. I am trying to have 2 drop down lists and based of the entry in each list I would like a cell to list the specific info that is related to the two choices in the drop down lists. Drop Down list 1 Drop Down list 2 Name of client...

I download an entire trial balance from our accounting software into excel. I then map out each account to create a balance sheet. Works like a charm... However, I need to re-download a month that was corrected in the accounting software. While I can manually delete the rows and paste the...

Hey guys, So our LIMS system is down and I'm finding our labelling system is taking forever to do manually. I am wondering if there is possibly an easier way to program this... Some background: Columns labelled LIMS Number and Type will be emailed where we copy from the email and paste into...

Hello is there a way I can have excel automatically select cells column A, B, and C together when i select any of the 3 columns. For ex. the info in B1 and C1 are info about A1 I want all 3 to be moved together at all time and not have a choose to moving or copy one cell with out the other...

I have two worksheets. One is old, one is new. The new sheet needs the same info pulled in as the old sheet, but in a different order, by last name. There are two columns of info associated with the last name, each will need pulled in separately. I have tried a couple different formula with no...

Morning, When i click the drop down arrow on a Combobox i see the only one option to select of which in this case is N/A But below that option there is a empty space/gap. Please advise how this can be remove. Here is some info to assist you. Code for the Combobox. 'INVOICE NUMBERDim lastroww...

I have been given some wonderfully complicated and not at all well formatted Excel spreadsheets at work. These spreadsheets are kept by the nurses I work with and have important patient info in. I'm trying to consolidate the data and then clean it in a hope to make everyone's lives easier. So...

Morning, I have a userform that opens when i open my worksheet. I am having difficulties with the code where i press the CommandButton2 to then transfer the data ive just entered in the TextBoxes on my form to my work sheet. Here is some info to help you. The information needs to be placed...

Hi Guys I have a file where it has various combo boxes with info. I would want a code to send an email with the info in the subject line and in the body of the mail File loaded here http://s000.tinyupload.com/?file_id=43617830343183525506 Regards CT

I have a spreadsheet that has confidential information. I know how to lock the sheet and hide the confidential info that is not the problem, What I want to know is there a way to have two levels of security. Two different passwords to open more or less. Some people need to see the confidential...

I am trying to make timecards that update from a master list. First worksheet - master list with rows of info (name, acct code, time in, etc) Second worksheet - timecard template (cells call upon info in the master list) I can make sequential worksheets based on a list (column A), but I...

Hi, I want a simple drop down list in a vba userform. The list is from sheet 2 a7:a20. I have it where the form will activate but can't figure out the dropdown. Also, if they dont click one I want a form to show that says missing info. I have that made. Its called missing info. Summary userform...

Hello I have an issue with a macro running till the end instead of waiting for a called userform input. Below is the the code and the called userform code. As you see the SamOpt2x macro finds a cell containing "Sample #1 " and selects the cell. At that point the userform macro is called and...

Hi All Got a simple userform - 1 combobox and 4 text boxes. The combobox has a list of all the sheet names. when a button is pressed, I would like the info that is in the 4 text boxes to be transferred to the next available row in the correct worksheet. is this doable? thanks neil