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:] Code To Save Worksheets As Individual .txt But Only The First 9 Columns Of Each sheet
  2. [SLEEPER:] VBA Books/Courses For A Novice
  3. Help Needed: Picking Shortage Corresponding Date
  4. Copy Used Row
  5. Macro to create new sheets when master is updated
  6. Some last problems with barcode prog. ' SetFocus, Barcode Length ,Autosave'
  7. [SOLVED:] Time Rounding VBA (Custom Function?)
  8. Nested Loop to create multiple series in a single chart. Where did I go wrong??
  9. Pls correct my code (sending mails)
  10. [SOLVED:] Filtering unique data & Remove duplicate rows & save unique record range in new book
  11. How to check if a cell contains something or not
  12. [SOLVED:] Template SaveAs on First Open
  13. Corrupt data in workbook?
  14. Path/File Access Error - Replacing text in xml with text from excel
  15. VBA code to subtract the time diferences in the userform.
  16. Data Merge - Identify Rows Not Pulled Over from Sheet2 into Sheet1 - VBA
  17. Problem with Folder Picker
  18. [SOLVED:] VBA Code to Match US Region to the State that is entered
  19. Get multiple values from sheet and assign to textboxes
  20. [SOLVED:] Compare two lists of numbers
  21. [SOLVED:] Delete row if it contains a certain word or phrase - and use array
  22. Extracting the URLs from a tweet
  23. [SOLVED:] If Cell is Highlighted -> Copy Row and Paste in Sheet2
  24. Cumulative sum based on a condition
  25. small logic is missing (auto mail)
  26. [SOLVED:] Left & Copy
  27. [SOLVED:] Combine worksheets and move row and columns
  28. [SOLVED:] Help Loop and Count if more than one unique
  29. Copy Worksheet to another Workbook - VBA
  30. Looping to find difference in time within string
  31. For loop delete entire row if cell is blank
  32. [SOLVED:] VBA Celloffset function in For Each Cell function not work
  33. Compare 2 different excel sheets
  34. Delete duplicate rows if they do not contain a specific word
  35. Run "x" number of random draws and calculate totals against a pre-defined set.
  36. Read outlook emails copy to excel.
  37. Range not selecting correctly?
  38. WORKDAY #VALUE ERROR
  39. [SOLVED:] Find unique records between 2 sheets and delete
  40. Active X component cant create object
  41. Time of creation of shape
  42. VBA code to lock the active sheet
  43. Can't get code to loop through worksheets
  44. How to check for conflicts in a schedule?
  45. VBA select/send email based off criteria
  46. run msgox at certain times of the day only if a specific workbook is still open
  47. Convert table of contents to another format
  48. [SOLVED:] A text box in excel that contains a Picture taken from a file
  49. path string in cell
  50. [SOLVED:] Linking Label Caption To Textbox
  51. userform menu problem
  52. [SOLVED:] How to reuse variable value across Private modules
  53. ThisWorkbook.SaveAs fails at second attempt
  54. disable close "X" button
  55. Using different Range in the body of email based on row criteria - Appointments
  56. Code error 9. Create a workbook and worksheets in relation with variables
  57. [SOLVED:] Fill Series of Sequential Numbers in Column A Based on Last Value in Column B - VBA
  58. [SOLVED:] Combine two arguments into one.
  59. [SOLVED:] Copy sheet and paste values - VBA
  60. Concatenate Multiple Cells
  61. Object required (Error 424)
  62. [SOLVED:] Copy values only not the formats.
  63. VBA to search in sheet1, match data in sheet2, return search results in sheet1
  64. Simplifying and looping VBA
  65. Modify VBA code for Advanced Filtering
  66. [SOLVED:] duplicating range
  67. ComboBox change for multiple comboboxes
  68. VBA auto outlook 2016 to send e-mail based off criteria
  69. [SOLVED:] Formula to calculate AVERAGE but only to last used row in a grid.
  70. [SOLVED:] Average values within time range for matching header
  71. Compare if any changes then highlight
  72. paste special values for multiple pivots
  73. VBA
  74. VBA
  75. [SOLVED:] Grab data between two dates using arrays
  76. VBA Loop help (Error Loop without Do)
  77. Excel custom data validation with drop down list
  78. Index / Match / and search for result between two dates and a little bit more complex
  79. [SOLVED:] Got Excel< 2007? Test if "Action Will Reset Project"
  80. Select added value from dropdown menu, program output
  81. Everytime I open my excel file open this file as new excel instance
  82. AverageIfs Dynamic Formula -Criteria Not Working?
  83. Making a leave tracker with VBA
  84. [SOLVED:] Create a new sheet / workbook for all Unique values (Including Pictures / Images)
  85. Two Workbooks - Search for Values in Workbook 2, Copy and Paste in Workbook 1
  86. disable cells DataValidation
  87. [SOLVED:] Need Some Help with SumProduct
  88. [SOLVED:] How to find which columns are being used in active chart
  89. [SOLVED:] "Run-time error '1004' on code to remove the ellipsis (...) character from a column
  90. [SOLVED:] Setting a found item to a Variable
  91. [SOLVED:] Replace certain cells in rows with values from same rows but in different column
  92. Pasting the contents from one sheet to a row after the last active row on another
  93. Not enough memory + Excel 2016
  94. Limiting User Entry on A Userform Combobox NOT working
  95. [SOLVED:] Last User Save
  96. [SOLVED:] Copying entire row from Sheet1 to Sheet2 if values in multiple cells matches
  97. [SOLVED:] Default to current date in textbox
  98. [SOLVED:] Reposition cursor in cell that contains the error
  99. [SOLVED:] VBA question on counters
  100. [SOLVED:] Error 1004
  101. VBA - Consolidating information from one sheet from multiple workbooks in the same ma
  102. [SOLVED:] Dynamically call function in sheet's VBA module
  103. Copy Data without Activating a Tab
  104. How to extract specified data to the other worksheet?
  105. Excel Error when arguments with multiple parameters are passed
  106. How to amend this code in order to copy the inserted comment also?
  107. [SOLVED:] Can someone tell me why this doesn't work.
  108. [SOLVED:] Type Mismatch Error
  109. Help subtracting sales from order
  110. For...Each + Merging Cells Leading to Error 2042 (Type Mismatch)?
  111. Macro to copy row, base in condition, into the botton of the table
  112. XMLHTTP - communicate with server - not working on Japanese OS
  113. Initiating a new instance of a class object
  114. Save worksheet as pdf using cell value and loop through work sheets
  115. VBA code to find current user default download folder, then open a specific file
  116. staffing rotation in excel
  117. [SOLVED:] help about my code (get data)
  118. [SOLVED:] Search a pdf file depended on textbox value in multiple folders and subfolders
  119. create filenames from the values in a MS Excel spreadsheet
  120. [SOLVED:] Compare 2 colums of different sheet and copy values for matching data
  121. Multiple Entry Dependent Drop Down Macro
  122. VBA Converter Required
  123. [SOLVED:] VBA Calculation
  124. VBA Insert array formula base on criterias
  125. [SOLVED:] VBA Question on InputBoxes to Fill Cells on Worksheet
  126. [SOLVED:] VBA Formatting Help
  127. Codes working for 2 templates but not the 3rd
  128. [SOLVED:] Formula for placing ascending and descending numbers
  129. Can't add new item to the listbox while running the userform
  130. Hyperlink
  131. VBA Error/Trapping/Identification
  132. [SOLVED:] VLOOKUP with variable workbook and worksheet names in macro
  133. [SOLVED:] Create a new workbooks for each Unique value
  134. [SOLVED:] merge 2 VBA enabled worksheets to 1 sheet
  135. [SOLVED:] VBA Code - setting cell background color doesn't hold with different selection.
  136. Help with time if/then in VBA
  137. VBA Help: Date/Time Stamp functionality
  138. Excel VBA to count the ADDITIONAL comments added to a cell
  139. Excel vba code to automate IE.
  140. [SOLVED:] Excel VBA -Comparing Two arrays
  141. Trying to only retrieve files that i do not already have
  142. Creating a dynamic piechart
  143. Vba to highlight the cell and remove duplicates
  144. [SOLVED:] Listbox - calculation based on selections
  145. [SOLVED:] (HELP) add multiple process to my code
  146. Passing an item and its key to another collection
  147. Error connecting to MySQL using VBA (3709 error)
  148. VBA code to store and count data filtered by other columns
  149. Identify keyboards with vba 7 (Excel)?
  150. [SOLVED:] grabbing error values
  151. [SOLVED:] Baffled by Runtime Error 1004 - Help Please
  152. [SOLVED:] return the value from 'A' which has the largest sum of values in 'B'
  153. Formula producing mixed results, may required VBA
  154. [SOLVED:] Process too long for counting received,sent mails etc. with Outlook
  155. VBA to loop through each row and subtract if conditions met
  156. [SOLVED:] Importing worksheets and retaining file order
  157. VBA error with parsing JSON
  158. Automating Data Retrieval From Terminal Emulator (OutsideView) with VBA
  159. Splitting multiple worksheet
  160. Filter Data and Copy to new worksheet
  161. [SOLVED:] Sorting in Excel VBA
  162. [SOLVED:] Pivots auto sort and dollar sign needs to be added
  163. [SOLVED:] To Uppercase
  164. [SOLVED:] Excel Worksheet_SelectionChange event not firing at all? (on both Office 2013 & 2016)
  165. [SOLVED:] Index & Match formula error
  166. Find values
  167. [SOLVED:] Problems with GetSetting function
  168. finding last column used and insert new data weekly
  169. Fliter listbox using checkbox
  170. Open File for Output hangs
  171. [SOLVED:] Setting the date as dd/mm/yyyy from a combined field
  172. dynamic way of Filter and delete
  173. [SOLVED:] Retrieve data(Time, From, subject, category) from Outlook inbox to Execl
  174. [SOLVED:] Is possible to show the UserForm of another Excel file?
  175. [SOLVED:] Application Defined or object Defined Error 1004 after every cell update
  176. [SOLVED:] Named Ranges - Same code, but one is cast as Variant and the other a Range?
  177. [SOLVED:] VBA Code to filter a list, then create new list in a new column
  178. FormatConditions.add to change cell color when something is entered
  179. [SOLVED:] Is MsgBox Suitable ?
  180. [SOLVED:] VBA Pivot Table- Datafields Horizontal to Vertical
  181. Run Time Error 13 (Type Missmatch)
  182. Excel templates and save as workbook
  183. [SOLVED:] Transpose non organized data
  184. formula error while cut/copy of cell contents
  185. [SLEEPER:] How to pick one webpage each from a collection of web page list!!!
  186. VBA UserForm Movement limit
  187. Fill Formula Down Column when Rows Inserted
  188. [SOLVED:] Help with SaveAs PDF
  189. [SOLVED:] Combining Data from multiple worksheets to a printable worksheet
  190. VBA - Excel Assistance on consolidating multiple workbooks into one
  191. [SOLVED:] Changing a cell font color upon cell entry & exit
  192. Error during import from webpage -> *** requires a JavaScript enabled browser.
  193. Paste multiple formatted word paragraphs into single Excel cell
  194. Arrays Compare
  195. Excel comments: a registered macro that doesn't work
  196. [SOLVED:] Need help with an vba macro for excel that adding an 0 in a number combination
  197. [SOLVED:] New-work-assignment / Sort data
  198. [SOLVED:] UDF called by another UDF sees Caller as an Object
  199. [SOLVED:] Countif or Similar Help Required and advise on Named Ranges
  200. How to fix this problem? "unable to set the visible property of the pivotitem class"
  201. Excel - Identify Shapes by Content
  202. UDF calculation very slow in excel 2016 (faster in 2010)
  203. [SOLVED:] Input cell value based on multiple dropdown list to populate
  204. Rename files using criteria in Excel
  205. VBA query while inspecting element on webpage
  206. Sleeper: Get duration of mp4 files
  207. [SOLVED:] copy rows if number doesn't exist in all worksheet
  208. [SOLVED:] How to get the index of ActiveChart
  209. excel file saving issues
  210. user form(vba macro)
  211. get file paths based on name criteria from folder
  212. Problems with xl2007
  213. [SOLVED:] Update column of selected items in Multi Select Listbox
  214. [SOLVED:] Recon between two spreadsheets across various columns
  215. Decorate my sheet as an interface
  216. Remove Duplicate Row IF Older
  217. [SOLVED:] Copy Data from one sheet to New Workbook with the New Header Name
  218. [SOLVED:] Assign value to pie chart
  219. Highlight and popup message Between employee dates are overlap using (vba)
  220. [SOLVED:] Macro for Conditional Formatting
  221. How to capture the lock time and event of System by vba?
  222. Sleeper: Gap in between the words in excel
  223. Help--Can't extract data from Mysql using cell content as select condition
  224. Union range vs Arrays (error out of range)
  225. [SOLVED:] Date Format in VBA
  226. sorting among workbooks
  227. [SOLVED:] callback an EditBox in the Ribbon
  228. [SOLVED:] ListBox Object -- Inconsistent behavior (sometimes unresponsive?)
  229. [SOLVED:] similar cells - grouping
  230. Producing hundreds of Multiple Regression analysis scenarios simultaneously
  231. Automation error
  232. [SOLVED:] Copy a column from excel and paste in the "To" section of a new email in Outlook
  233. Export single row from given sheet & append into existing MSAccess table.
  234. VBA replaces long number with # sign (Excel 2010)
  235. It's possible to add a Word document with a customized name?
  236. combine mutiple values into single cell based on criteria
  237. Should be a simple fix but not sure how to move and tweak my If statement....
  238. Relative Paths within Excel for CSV imports
  239. Looping Mirrored Cells between Worksheets
  240. Copy sheet to new workbook
  241. VBA code for multiple column loop - help please!!!
  242. Transfer row from list box to another sheet VBA
  243. Repairing & rebuilding workbook error
  244. Deleting All True Empty Rows in a worksheet
  245. VBA - HIDE/UNHIDE Rows Based on Output of a Formulated Cell
  246. (Single Workstation) Error, how to reset? Macros via Ribbon UI aren't firing...
  247. Specify which folder to open when using Get Open Filename
  248. Autocomplete value entered into a cell from a list in another workbook
  249. [SOLVED:] Remove duplicates from Rows with the last Row only as reference
  250. Quick way for removing rows