PDA

View Full Version : Excel Help


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 [140] 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174
  1. [SOLVED:] need help understanding How to invert number. please
  2. Returning multiple results with Index/Match
  3. Lookup value in column and get result from relevent page
  4. [SOLVED:] Select case debug error
  5. [SOLVED:] Change picture depending on choice
  6. Select multiple sheets now not working
  7. Import sheets
  8. Populate 2nd tab by taking data from 1st tab
  9. [SOLVED:] Find max min of subsets only after Instruction given
  10. Dynamic Conditonal Statements Help
  11. Set Range to Existing Range Name based on criteria
  12. Macro to loop through solver and post results to separate sheet
  13. [SOLVED:] 424 Error, but object is in place
  14. [SLEEPER:] Dynamic tax calculator
  15. [SOLVED:] Excel 2013>VBA>Array>Fill with loop
  16. Web Scraping - Why does the code stop?
  17. [SOLVED:] Copying, naming, and saving a master workbook
  18. Extracting data from a Sheet-VBA Help
  19. [SOLVED:] Small problem with my code
  20. Create command buttons based on sheet names in UserForm1
  21. Need help hi lighting numbers with formulas in a cell
  22. Need Help Duplicating dates in a column, with a VBA. Please
  23. Assistance with data counting in VBA
  24. Count number of occurrences of text in the same cell separated by ";"
  25. [SOLVED:] Vba code that creates an input mask for a password ***** in an input box
  26. [SOLVED:] sync 2 seperate gps times in two different columns
  27. Excel VBA to open Word doc, then populate, then Save it as PDF
  28. [SOLVED:] need help to construct vba to label order of value in a cell and rslt to nxt col plea
  29. When macro tries to modify a chart in a protected sheet (UserInterfaceOnly) -> Error#
  30. Macro of copy and paste loop
  31. How to get the data from website (javascript) to excel by using vba
  32. [SOLVED:] VBA to delete cells based on cell selected and move cells up
  33. Visible cells
  34. Formula Chart vs smae chart without specific item
  35. [SLEEPER:] Lock Cells based on criteria
  36. VBA Varible IF Statement
  37. [SOLVED:] need help please in contructing a macro for excel, please!
  38. Immediate window for changing dates
  39. Automation error during mail merge in Excel VBA
  40. [SOLVED:] VBA remove specific characters in cell
  41. Automatically move to next sheet and perform Macro
  42. Macro to copy data rom all the files in folder and paste in single sheet
  43. Macro to copy data from all the files in folder and paste in single sheet
  44. [SOLVED:] Need Help with a Conditional Format
  45. [SOLVED:] List 4 number combinations
  46. Problems using For Loops and Find function
  47. Find nearest greater value
  48. [SOLVED:] Searching in specific sheets problem
  49. Remove page info in cell
  50. [SOLVED:] Excel splash screen not working while macro runs
  51. Fill Down, but not locked into one value.
  52. VBA function for representing click on ribbon icon (command bar) icon
  53. Compare ID and Header Two Worksheets
  54. reorganizing cell data on a diferent sheet
  55. rounding number problem in vba
  56. macro to copy exel data to powerpoint
  57. VBA code Problem
  58. Validate Date and Compare Amounts
  59. vba column to pivot table converted field
  60. Copy File List - Show Which Files Were Copied Succesfully
  61. Produce report on new page with current date
  62. Salary calculation problem
  63. [SOLVED:] How to display Elapsed time on a Excel User Form ( Using Excel 2007)
  64. Terminology
  65. [SOLVED:] Need help creating a macro that produces a dual cursor
  66. Copy multiple tables from multiple sheets to a master list sheet
  67. calculate salary for specific record
  68. PivotTable not functioning
  69. Need Help: Changing Sheet Index Property in VBA code
  70. Macro to expand SUMPRODUCT Formula
  71. VBA Code to go through one column cells, I don't have range, I have only one column?
  72. [SLEEPER:] How can we convert arabic numbers to English number using VBA in Excel?
  73. Help With For Loop
  74. [SOLVED:] VBA merge excel sheets into new sheet with some conditions
  75. [SOLVED:] Lookup or Index Match Formula
  76. Not getting response in soap service call from excel vba
  77. [SOLVED:] How to suppress JavaScript errors when loading a webpage into a WebBroswer control
  78. Basic VBA Help with Ifs, fors, and relative referencing
  79. Userform Multiple WebBrowser issue Excel 2010
  80. [SOLVED:] Excel 2010 vs. 2016 Functions won't Work
  81. Exporting Query from Access to Excel - Inconsistent Results
  82. [SOLVED:] Create a workbook from a worksheet and name it from a list
  83. Populate data from 2 columns
  84. Pause VBA loop until sheet is recalculated
  85. Need help in excel vba
  86. loop through checkboxes
  87. Find function
  88. Userform Errors
  89. [SOLVED:] Pivot Time?
  90. Well versed in formulas but NOT VBA Code - Help a noob!
  91. Combobox: Optionbutton dependent lists
  92. [SOLVED:] CF in Pivot Table
  93. [SOLVED:] Extract & paste the filename into another workbook
  94. Transposing multiple columns into one column while repeating the names
  95. Multi ComboBox2 and TextBox how to update this whit less code
  96. Run time error 91
  97. [SOLVED:] Clear all cells vba
  98. Macro to replace part of a formula with result
  99. vlookup within for loop vba
  100. [SOLVED:] Need help restructering Macro for specific result, Please
  101. [SOLVED:] Inserting Rows based on cell differences and interpolating in between
  102. Class in Excel
  103. [SOLVED:] VBA run code if 3 rows and different code if 7
  104. Run time error 9 : Subscript out of range
  105. Background cell color on filter in vba
  106. Click event for a group of option buttons in a Frame
  107. [SOLVED:] Need help restructuring a coloring cells code macro.
  108. [SOLVED:] Tricky one, Changing vertical list to horizontal list...
  109. [SOLVED:] call shell and execute in cygwin using excel vba
  110. Sending Email from excel cell with attachment
  111. [SOLVED:] Link embedded objects
  112. [SOLVED:] VBA to Verify Data
  113. Send multiple different pdf to contacts on list
  114. [SOLVED:] Rename excel worksheets based on values contained in 1 excel tab
  115. [SOLVED:] I need help fixing macros to high light the correct data. please need help with this!
  116. VBA Code for Combing Lists
  117. [SOLVED:] ComboBox Linked Cell
  118. Create OLAP Connection in Excel 2010 via VBA Code under the Button
  119. [SOLVED:] Textbox validation
  120. [SOLVED:] VBA Loop Through all open Workbooks
  121. [SOLVED:] Unable to select a value in a DropDown List in a Webpage using VBA
  122. Code to generate plots for different variables with different range in loop manner
  123. [SOLVED:] Combining Columns into One
  124. [SOLVED:] Something like vlookup
  125. only run one email command and other processes based on user prompt using excel vba
  126. Stop auto text to columns upon opening
  127. Source Password Protected
  128. Auto update data to diffrent columns VBA code needed
  129. Save the workbook with a time stamp in the same folder
  130. Need help with program deleting rows
  131. Problem changing cell color on button click
  132. [SOLVED:] Disable right click insert rows
  133. VBA transfer columns from two reference sheets to a master sheet with different colum
  134. Delete is taking to long, and I dont know another way to do it.
  135. From DDL field
  136. Formula for value in Row
  137. [SOLVED:] How to post only the SaveAs location that a user selects to a Worksheet cell
  138. Excel - lock range of cells in a row based on value in a cell
  139. Calculate Net Salary
  140. [SOLVED:] Need help rearranging VBA to search from a rangei a range for duplicates to HL please
  141. Need help! constr a macro that copies data and pastes in multiple new range in WB
  142. Compare three work sheets problem
  143. Need Macro Help for making Transpose List
  144. Named Range !REF# error
  145. Get oldest file from the folder
  146. [SOLVED:] Point in Polygon
  147. [SOLVED:] Generating random outcomes based on probability
  148. Display warning alerts
  149. Help with formula for scenarios
  150. [SOLVED:] Help locking a column to prevent editing.
  151. VBA code in Excel opens Word template and fills bookmarks, but can't get correct form
  152. [SOLVED:] Selecting a file to email from Excel 2010
  153. VBA code to automatically click an element of a toolstrip
  154. Changing cell color
  155. Cannot get excel to email sheet via outlook
  156. Creating a curve graph to show negative position to positive position
  157. VBA Open a Excel file and then copy charts to other excel file which is already open
  158. what should be the VBA code for my problem?
  159. Unable to fill text box of a #32770 window [EXCEL-VBA]
  160. VLOOKUP question
  161. [SOLVED:] At my wits end
  162. [SOLVED:] Verify no files are open in a folder
  163. Gathering sheet names and displaying them in a specific sheet column
  164. [SOLVED:] VBA operator problem
  165. Print PDF batch scripting for a noob
  166. [SOLVED:] import a .csv generated from a php website link
  167. [SOLVED:] Loop through each excel file in a folder
  168. Split Multiple worksheets to Multiple Workbook based on Column Value
  169. [SOLVED:] Multiple Dependent Checkbox to hide unhide sheet
  170. How to Call a user defined input within range function ? or Global Call ?
  171. Help with lookup formula
  172. [SOLVED:] vba code to offset negative values - left or right and make positive
  173. VBA does not print
  174. Return the value to the right of the cell
  175. [SOLVED:] Macro to move back to previously active cell
  176. [SOLVED:] WINHTTP Request Returns NOT FOUND and UNAUTHORIZED ACCESS (VBA EXCEL)
  177. match work sheets
  178. range of object failed xcel 2013
  179. date pick error
  180. Delete all rows except names input by user
  181. [SOLVED:] Need to create a separate worksheet for each row of data
  182. [SLEEPER:] Macro that highlights specific rows yellow if a cell is green and a date varies
  183. Make code shorter
  184. [SOLVED:] Calculate power
  185. Searching for cells that contain a specific text constellation
  186. VBA HELP!!!
  187. [SOLVED:] Need help with current macro run the x vlaues as letters. Please!!!
  188. Can you search sort for a specific color and number
  189. [SOLVED:] Need help Restructuring current macro to translate different type of data, please!!!
  190. Save a copy of an excel file as Read Only
  191. Sleeper: Need help to create Scatter plot chart through VBA code
  192. How to search a specific text constellation?
  193. How to search a specific text constellation?
  194. Excel VBA to download file from url
  195. Extracting Unique Values in Column that meets criteria
  196. How to search substring against range and if found remove it?
  197. sum every sheet cell into a sheet easy
  198. remove line or lines from a text file using vba if checkbox is true
  199. User Defined Function not working when entered in Excel
  200. Vba Web Project - Data from web to Excel sheet
  201. Copy one cell of a worksheet of a workbook and paste to a master workbook many times
  202. VBA Error 91
  203. paste as text from other applications
  204. [SOLVED:] Need help to transform one spreadsheet into another form of spreadsheet.
  205. [SLEEPER:] How to setup clock as per zones, macro should work when excel is open
  206. Msg Box if cell left blank
  207. [SOLVED:] Finding the active cell in other work book
  208. [SOLVED:] Revert Scientific Notiation to the Text that was Entered
  209. Having an Excel file open a website at a specified time
  210. [SOLVED:] UserForm RowSource Named Range Crashes
  211. Inventory System
  212. [SOLVED:] VB Excel, Count shapes with same color
  213. Can't copy cells' content into another workbook
  214. How to search column and highlight values that are not in dictionary?
  215. Retention Report Automation
  216. Populate spreadsheet cells based on multi select listbox and combo boxes
  217. Excel2013 or 2016 on Android Tablet with VBA
  218. [SLEEPER:] How do I save a value from a combobox on a userform to my sheet where ......
  219. Next record problem
  220. [SOLVED:] Show the Solver Dialog Box
  221. [SOLVED:] Copy Paste Ranges - Listed in Column A
  222. [SOLVED:] VBA code to find the string and paste the whole sentence in another cell
  223. Integer Overflow
  224. COMBING MACROS
  225. [SOLVED:] How to compare two Strings and do some find-copy-paste operation
  226. Excel templates to PDF
  227. [SOLVED:] Type mismatch error on startup
  228. [SOLVED:] excel vba search text in range and retrieve results in a textbox
  229. Problem for salary calculation
  230. If M column starts with phone number shift K,L and M cells left.
  231. [SOLVED:] File not found error when trying to attach PDF to Email
  232. Transpose or Copy Text from text to another Text box and Undo when necessary
  233. Filter/sort columns in another sheet
  234. Automatically pull new data VBA
  235. Looping Countifs with Excel Formulas
  236. dynamic graph based on drop down list
  237. VBA - Finding a value in column A, selecting that row, pasting it above with formulae
  238. VB Excel, Data Not able to auto refresh
  239. VBA Code for Searching\Renaming files in a folder
  240. Automatically increment single cell from 15 to 150
  241. stop incrementing
  242. VBA code help to sum values in conditionally formated cells
  243. [SOLVED:] How to count no of shapes in a group?
  244. Any suggestion for VB self-learning resources?
  245. VBA Macro for taylor Series of Sine (x)
  246. Listing rows associated to a value in Col A, by selecting related value in Col B
  247. VBA - Draw line to next high value
  248. Select PivotItems from to...
  249. [SOLVED:] Split Cells that have Alt+Enter Text Into Multiple rows and fill rows accrodingly.
  250. VBA Coding help - Multi-page User Form, vlookup, and INTERCEPT