Excel vba Related Problems & Solutions

19 tags
Refine Tags
Search Tags:

Start a discussion

Results 1 - 19 of 19
VBA Code copy data to sheet 2, offset, mark with X current
Summary: Good afternoon, I'm currently working with excel to make a VBA code. To start of from Sheet1 column A2 start copying the data to Sheet2 A2 and start g...

[Solved] Use VBA to stop formulas from being deleted
Summary: I have formulas in that if I select the client then the terms,address,client name and vat number populate automatically. But if I say save and new in...

Excel VBA Insert rows based on input
Summary: I am trying to make an VBA formula to insert rows based on what sort of value is in a certain column. If a number is put in column B, I want it to aut...

[Solved] (Easy) Excel VBA Conditional copy paste components of a row
Summary: Hey there! I am looking for a way to automatically copy paste values from one sheet to another based on the contents of the column in the following wa...

[Solved] Excel VBA Assistance for pwbk module
Summary: I need VBA assistance with code that will immediately autofill the specific value “NOT APPLICABLE” in Column W, whenever a report user selects the...

[Solved] Excel Macro to match set of values to another through edits
Summary: Hi folks! I've tried my hand with some macros and done OK but what I want to do here is beyond me and need your help! What I'd like to do is search th...

[Solved] How to lock buttons & textboxes on a work sheet?
Summary: LOCKING CONTROL BUTTONS IN PLACE..USING ACTIVEX OPTION BUTTONS, TEXTBOXES, LABELS AND COMMAND BUTTONS ON AN EXCEL WS...WOULD LIKE THEM TO STAY WHERE I...

[Solved] How To Bold Variable Text In A Concatenated String In Excel
Summary: I have applied the code from the question posted March 20,2016 (http://www.computing.net/answers/office/how-to-make-bold-fonts-in-a-concatenated-text-...

[Solved] How can i find data in a sheet and copy to alternate sheet
Summary: Hi, I have a sheet that can have a varying amount of sheets. I am trying to do a macro that will search all sheets (from sheet 6 to last sheet) and ...

[Solved] How can I used VBA to create a new timesheet?
Summary: I've created a timesheet workbook within excel for my staff to use from one pay period to the next. Within the timesheet, staff are able to track thei...

Copying data to another worksheet based on criteria. - VBA
Summary: Maybe I'm just over thinking this, but I couldn't find anything about it anywhere. What I'm trying to do is copy a range of cells from a table on one...

[Solved] VBA to use PasteSpecial instead of Paste Destination
Summary: Hi, I have the following macro that will copy and paste form one worksheet to another. I would like change this to paste the values and I have not be...

SUMIF formula to VBA
Summary: =IF(SUMIFS(FTMRC,FTMRC,VALUE(40),CTN,RPA!E5),40, IF(SUMIFS(FTMRC,FTMRC,VALUE(45),CTN,RPA!E5),45, IF(SUMIFS(FTMRC,FTMRC,VALUE(30),CTN,RPA!E5),30, IF(SU...

[Solved] auto populate text from data validation list
Summary: Hi, I want to auto populate my data in column H. It's a vlookup in macro. I have a data validation list in Column G from row 12 to 100 and I want to a...

[Solved] Data Validation Intersect vba
Summary: hi.. i have a template where in 2 columns are related to each other. I want to automatically create a validation list for the other column based on wh...

vba code to copy only the values from cells not formulas
Summary: i have this code to copy the values from a cell in column G in column C. but i have a problem because this code copy the formulas from cells,that i wa...

[Solved] random sampling excel vba
Summary: Hi, I actually have a data where there is 2 classification - Approve and Missing I need to have a random sampling 50 for each classification but these...

[Solved] excel VBA code to produce permutation list to text file
Summary: I want an excel VBA code that will read from a text file and check each item in text file against all the items in sheet1 to see if it finds any match...

Excel VBA Cell value changes
Summary: Hi all, can you help please - When a date (dd-mmm-yy) is entered into any row column 'W' Copy it to same row column 'AU' . When a date is removed from...

1


Ask Question