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?
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:
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...
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...
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...
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...
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.
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...
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
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...
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.
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...
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?
I was hoping that someone could give me the code for thefollowing.
I wanted a pop up box for users to fill in 4 columns ofinformation.
Col A would be “Date” B “Site” C “Tonnage” D “Reason” isthere a way that it will auto fill the newt row? So row 1 has the header titleso the info would need...