Log in

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:] VBA Copy and Paste data form one workbook to another.. Problem is data change every w (8 replies)
  2. Problems with simple counter (2 replies)
  3. [SOLVED:] NEED HELP RESCTRUCTURING MACRO TO FIT MY WORK SHEET, PLEASE. (3 replies)
  4. Speedup VBA (4 replies)
  5. excel formula and vba automation help (6 replies)
  6. Available Procedures in COM add-in (1 replies)
  7. INSERT OVERWRITE INTO correct syntax? (2 replies)
  8. [SOLVED:] Editing the contents of a Match Index Cell through VBA (2 replies)
  9. Email and HTML (5 replies)
  10. TOC macro to skip displaying hidden sheets (4 replies)
  11. Newton's Method Iteration Code in VBA- No errors but will not output (3 replies)
  12. Automatic numbering up, with two matches (26 replies)
  13. Sleeper: New line in formula & Join Text (2 replies)
  14. Montly, Weekly, Daily Attendance (11 replies)
  15. [SOLVED:] Tab delimited text file issue (2 replies)
  16. [SOLVED:] Runtime error 1004 (4 replies)
  17. [SLEEPER:] Conditional VBA for Combinations (4 replies)
  18. [SOLVED:] Offset in an Array - Replacement (12 replies)
  19. Disable Sort In Shared Workbook (3 replies)
  20. To search a column in a database and to return all the entries found (2 replies)
  21. [SOLVED:] VBA Macro Stops at line 986 (11 replies)
  22. [SOLVED:] VBE Editor Select Module (2 replies)
  23. [SOLVED:] Transpose Excel data from rows to columns (6 replies)
  24. [SOLVED:] Struggling to apportion value 'dynamically' - Worksheet attached (7 replies)
  25. VBA Powerpoint formating (14 replies)
  26. If Value is >= 1 Take header and insert into row (1 replies)
  27. [SOLVED:] CDR CVS help needed (8 replies)
  28. VBA to use a variable filename (3 replies)
  29. [SOLVED:] LEFT Function to retain first 10 characters of cells with VBA (4 replies)
  30. Explain Formula (15 replies)
  31. Advanced Filter Help (2 replies)
  32. Vba Macro in Excel for exporting multiples files in Word with prompt (3 replies)
  33. [SOLVED:] Calling Textboxes created in runtime with a form how to reference in a loop (6 replies)
  34. [SOLVED:] Making VBA userform, ChangeButton does not work (2 replies)
  35. Link spreadsheets (1 replies)
  36. [SOLVED:] For loop inside IF statement (2 replies)
  37. Filter by named range in closed file (7 replies)
  38. Open PDF in WebBrowswer Control on Userform (0 replies)
  39. Sleeper: How to save as with fixed name and server location ? (9 replies)
  40. Updating database using userform dependent combobox selection (2 replies)
  41. Changing an Excel Userform does not work (3 replies)
  42. [SOLVED:] Simple Macro Help (8 replies)
  43. Chart - Excel 2013 - Series Highlight on Label mouse over (7 replies)
  44. search a column of keywords in a folder of .docs and match file names and string (27 replies)
  45. How to use buttons on userform (3 replies)
  46. [SOLVED:] Add a link button dynamically in 1 cell of each row (5 replies)
  47. Select Listbox Item by ComboBox Item (3 replies)
  48. [SLEEPER:] Upload File with winscp and sftp (8 replies)
  49. [SOLVED:] update a table between two Excels files with a condition (3 replies)
  50. [SOLVED:] ListBox - Population - Load For Each Worksheet (13 replies)
  51. [SOLVED:] Generating new ID VBA code (7 replies)
  52. Vba Need Dice Continue Rolling? (1 replies)
  53. [SOLVED:] Worksheet.Evaluate to Formulae (2 replies)
  54. [SOLVED:] Treeview not loaded in userform (6 replies)
  55. I need the cursor to go to the last non-zero in column C (3 replies)
  56. Web scraping (2 replies)
  57. [SOLVED:] DATE and TIME FORMATTING in Office 2007 (9 replies)
  58. Excel sending email format (1 replies)
  59. Help with macro filter sequencing (9 replies)
  60. [SLEEPER:] Create outlook reminder from excel (3 replies)
  61. [SOLVED:] Transpose date from column name (2 replies)
  62. [SOLVED:] Variable Not Defined Error (6 replies)
  63. Changing Vlookup to variable depending on search results? idk (1 replies)
  64. Refresh DB Connection Programatically (1 replies)
  65. Delete table rows where a cell in D contains certain numbers (1 replies)
  66. exportasfixed format specific range not working (2 replies)
  67. reformuler un tableau ce forme dans rapport Excel (3 replies)
  68. work hours with lunch break (2 replies)
  69. Check for headers in Excel (1 replies)
  70. [SLEEPER:] Referencing Classes ByRef vs ByVal (3 replies)
  71. Excel-Visual Basic UserForm Coding (3 replies)
  72. For Each inside another loop works only once after excel startup (7 replies)
  73. INDIRECT with Data Validation for a 3D formula (2 replies)
  74. PDF2XL (1 replies)
  75. [SOLVED:] Subscript Size (5 replies)
  76. [SOLVED:] Userform focus causes document in opposite window to minimize - Dual Monitors (1 replies)
  77. [SOLVED:] Highlight Offset Consecutive Column Cells (5 replies)
  78. Hit button and download file using excel vba on web page (2 replies)
  79. [SOLVED:] Can you keep a connection to a DB open? (5 replies)
  80. [SOLVED:] Trying to Create a Remove Last Button (36 replies)
  81. Want to fill data from Excel in to specific Form for Print Lable. (2 replies)
  82. VGA code to list files attributes and also arranged them with filter using buttons (3 replies)
  83. [SLEEPER:] countifs column with date (1 replies)
  84. Code to copy the active WS before a specific WS in the WB (3 replies)
  85. [SOLVED:] Macro to Print Worksheets Containing Specific Data (6 replies)
  86. [SOLVED:] Transpose Selected Cells Containing Specific Value (3 replies)
  87. [SOLVED:] Text to columns for every character in text file (3 replies)
  88. time to decimal format (10 replies)
  89. Close Open Text File - No Save Prompts (4 replies)
  90. Integrating Calendar with WorkSheet and UserForm (2 replies)
  91. Merge 2 Excel Worksheets together (4 replies)
  92. UserForm webBrowser ctl: how to detect 'no web page found' for a defective url? (1 replies)
  93. [SOLVED:] Going through a range (Looping?) (11 replies)
  94. CLEARCONTENTS OF CELLS WHEN OTHER CELL VALUE IS DELETED (10 replies)
  95. Textbox search conditionally (8 replies)
  96. Send Mail VBA LOTUS NOTES (1 replies)
  97. [SOLVED:] WorkSheets in an Array - Copy From (2 replies)
  98. OLAP Pivot Table - Variable number of filters (8 replies)
  99. [SOLVED:] Userform Assist - commandbutton to add multiple textbox (2 replies)
  100. List Box - Scroll Bar movement creating a ghost image of the ActiveX List Box (3 replies)
  101. [SOLVED:] Replace Exact String - Array (6 replies)
  102. Need to copy Some part of outlook mail body into excel through vba (0 replies)
  103. [SOLVED:] Help With Coding Structure (4 replies)
  104. [SOLVED:] Delete Rows Not Containing Array Term (4 replies)
  105. [SOLVED:] Array Step by 50 - Loop Incremental (4 replies)
  106. Macro to send e-mail for different recipients with different messages (4 replies)
  107. User Form Assistance (8 replies)
  108. Insert Excel Ranges in PowerPoint (4 replies)
  109. Filtering dates (8 replies)
  110. Print Documents Using File Path (1 replies)
  111. [SOLVED:] [Microsoft][ODBC Driver Manager] Data source name too long (7 replies)
  112. [SOLVED:] Combine multiple DIMs into one line instead of separate? (8 replies)
  113. organize data in groups with near equal Totals (7 replies)
  114. [SOLVED:] Summing individual rows, for overall group total (7 replies)
  115. Sendkeys and windows 10 (0 replies)
  116. Workbooks.Open - Convert .CSV (1 replies)
  117. [SOLVED:] VBA to compare multiple worksheets and produce report of cells where data varies (3 replies)
  118. copy data from multiple workbook ranges into one workbook sheet ranges (8 replies)
  119. Adding a Filter to a Pivot Table Inquiry (0 replies)
  120. Code that adds new appointments to Outlook (2 replies)
  121. Possible to apply conditional formatting across multiple ranges? (5 replies)
  122. Duplicates in named range (1 replies)
  123. Autofill column B based on dynamic range in column A in multiple sheets except some (2 replies)
  124. Copying excel ranges to powerpoint (6 replies)
  125. Naming a sheet to the current year (3 replies)
  126. Connect to two barcode scanners (2 replies)
  127. [SOLVED:] calculating time difference (6 replies)
  128. create Calendar from table (1 replies)
  129. [SOLVED:] When I move the cursor more than one cell become highlighted (8 replies)
  130. [SOLVED:] Copy paste Cell inside Table under certain conditions 2 (3 replies)
  131. [SOLVED:] Color Chart Columns by Conditionally Formatted Cell Color (4 replies)
  132. [SOLVED:] Printing Multiple Sheets to PDF (Excel 2013) (4 replies)
  133. Co-Authoring Issues - Auto-Updating (7 replies)
  134. Move informaiton based on a match (2 replies)
  135. Combination of cells to match a specified cell (3 replies)
  136. [SOLVED:] Code for a changable range in COUNTIF function (6 replies)
  137. [SLEEPER:] Macro for data validation with two condition and high-light row (1 replies)
  138. Error When Open From Protected View (1 replies)
  139. Move Cells Up after Content is Cleared (2 replies)
  140. Counting Employee hours booked (9 replies)
  141. [SOLVED:] Userform: Change Textbox color in loop (4 replies)
  142. Need help to click on ID using VBA (1 replies)
  143. [SOLVED:] Loop Thru Columns (2 replies)
  144. auto filter on adding rows (8 replies)
  145. Calculating Compliance (1 replies)
  146. VBA: How to prevent chart / picture / button from moving in Excel? (5 replies)
  147. [SOLVED:] auto filter and send by outlook (1 replies)
  148. Multiple Digital Signatures - on different TABS??? (1 replies)
  149. Launch windows powershell using VBA (1 replies)
  150. Check if Directory Exists (1 replies)
  151. Skip a fault 13 with an If code and go on with the macro (2 replies)
  152. syncing files (1 replies)
  153. Save to PDF (6 replies)
  154. [SOLVED:] SUM by colour (9 replies)
  155. Pick directory and merge 2 files into 1 workbook (4 replies)
  156. [SOLVED:] Run-time error 53 when moving files (2 replies)
  157. VBA script not working what have I missed (2 replies)
  158. Comparing to Excel Sheets based on a Key Column Value - Semi Working (2 replies)
  159. [SOLVED:] Problem with VBA code in Excel (2 replies)
  160. calculate time difference between cells (2 replies)
  161. Pasting an Image Into Cell, Merging Cells, and then Resizing (1 replies)
  162. vba help (7 replies)
  163. [SOLVED:] finding the value and paste in another sheet . (7 replies)
  164. [SOLVED:] Macro for moving the columns (1 replies)
  165. Copy paste values from another workbook if criteria is met (2 replies)
  166. [SOLVED:] trouble hiding columns (2 replies)
  167. [SLEEPER:] Implementing formulas with variables into VBA (2 replies)
  168. [SOLVED:] VBA macro for data filter and copy (2 replies)
  169. [SOLVED:] Display values based on matching column data (12 replies)
  170. Import Outlook-Taks in an Excel-Sheet (12 replies)
  171. sumproduct? (5 replies)
  172. Formula help please (18 replies)
  173. Using VBA in Excel macro to extract data from table and reconstruct table (2 replies)
  174. [SOLVED:] sum cells above every blank cell (5 replies)
  175. Creating a dynamic #N/A Filter for EXCEL. (4 replies)
  176. [SOLVED:] vba copy active sheet to closed workbook (2 replies)
  177. [SOLVED:] Array Prefix & Suffix Methods (7 replies)
  178. Get table values from HTML IE website custom generated table (2 replies)
  179. run-time error "4198" (1 replies)
  180. Target Specific Array Elements Group (2 replies)
  181. find a date in a range - exact match (11 replies)
  182. loop an excel table to update styles (17 replies)
  183. VBA code for attendance template - In time & Out Time (2 replies)
  184. [SOLVED:] How to find out URL from where on the website CSV data is benign downloaded (8 replies)
  185. [SOLVED:] VBA problem: Merge two sheets into one (18 replies)
  186. [SLEEPER:] Pasting a range into an email, while also adding text to body and keeping signature (1 replies)
  187. I want to find first 0 in column in vba (3 replies)
  188. [SOLVED:] VBA: Error when range(variant) condists of only 1 cell (12 replies)
  189. [SOLVED:] Print userform to PDF (22 replies)
  190. [SOLVED:] Opened/Populated by MS ACCESS, Excel WB can't see cell value on WB OPEN Event (3 replies)
  191. Copy Ranges between sheets with Cycles (7 replies)
  192. select a range using 2 address and find if range is empty/has data (6 replies)
  193. Using Wildcards (4 replies)
  194. VBA-XML-SEARCH ZIP AND HOUSE NUMBER (1 replies)
  195. Matching multiple values from different column (1 replies)
  196. capture few columns from xml file (9 replies)
  197. Keyword Identification and Changes (2 replies)
  198. [SLEEPER:] VlookUp giving random values instead of #N/A. (5 replies)
  199. Vlookup #N/A using VBA (1 replies)
  200. Saving a workbook with macros when they open it. (4 replies)
  201. Can I Change Textbox Languege ? (1 replies)
  202. Follow Up Question About the Ribbon (8 replies)
  203. Text Boxes visible not visible on user form (10 replies)
  204. Variable sheetname in formula (2 replies)
  205. [SOLVED:] Data grouping? (6 replies)
  206. vba - help removing selection (2 replies)
  207. [SOLVED:] HELP FIND HIGHEST VALUE USING VBA (3 replies)
  208. Copy Data to Next Empty Rrow (2 replies)
  209. Text Box formatting. (1 replies)
  210. [SOLVED:] Array formula - need formula to pick from 2 ranges to use in calculation (1 replies)
  211. Sleeper: Declare Global Variable - Private Worksheet (9 replies)
  212. [SOLVED:] Multiple Offset - Insert into (2 replies)
  213. [SOLVED:] Complicated formula, i'm at a loss (3 replies)
  214. [SOLVED:] form question (5 replies)
  215. Help Needed Regarding Linear Interpolation and Extrapolation (3 replies)
  216. Help: "Method 'SaveAs' of object'_Workbook' failed" - Tried different codes, no luck (3 replies)
  217. Using VBA to import BDH from Bloomberg (3 replies)
  218. VBA separate uppercase words from lowercase words. (2 replies)
  219. Hide Pivot items based on table (2 replies)
  220. Generate personal schedule from overview (3 replies)
  221. Delete out of date rows (5 replies)
  222. Authenticating Access to an External Database using VBA (2 replies)
  223. [SLEEPER:] User Form Help (3 replies)
  224. [SOLVED:] Change VBA code to fit 64-bit environment (18 replies)
  225. Loop for excel functions (4 replies)
  226. [SOLVED:] Sumifs? can this be done with a ranged criteria? (1 replies)
  227. using excel to collect and store data (6 replies)
  228. VBA: Splitting a big string with no good delimiters (6 replies)
  229. Worksheet edit VBA code (1 replies)
  230. Drawing two para (3 replies)
  231. [SOLVED:] How can I print the sorted array back into worksheet? (4 replies)
  232. [SOLVED:] Skip Empty Cells or Ones with a Word in Them and Run function (3 replies)
  233. [SOLVED:] Modify line of VBA code (5 replies)
  234. [SOLVED:] VBA TO Correct Date format (5 replies)
  235. Help with a Formula (3 replies)
  236. [SOLVED:] 2 Column messagebox spacing of data (5 replies)
  237. Deactivate "EDIT" after Digital Signature (or add Password)? (3 replies)
  238. [SOLVED:] PrintForm opens a 'greyed out' UserForm1 (8 replies)
  239. Copy paste loop Multiple sheets column wise (1 replies)
  240. Adding Formula in VBA ...Need help (0 replies)
  241. A way to speed up code VBA in for loop with ExecuteExcel4Macro (10 replies)
  242. Sharepoint coding (0 replies)
  243. Application Match error 13 (1 replies)
  244. [SOLVED:] Deleting a row (3 replies)
  245. VBA: compare values in columns and list the missmatches in a new sheet (2 replies)
  246. Excel Data Tables (3 replies)
  247. NEED HELP! Average Duplicates and Print them separately (2 replies)
  248. placing different windows on my screen (11 replies)
  249. How to sort Listbox with Multiple columns (3 replies)
  250. Sort Userform ListBox (2 replies)