Log in

View Full Version : Excel Help


Pages : [1] 2 3 4 5 6 7
  1. consolidate identical reports (2 replies)
  2. FORMULA EXPLAIN (4 replies)
  3. VBA USERFORM NOT LOADING dISPLAYING ERROR MESSAGE (6 replies)
  4. Help Needed with VLOOKUP Function to Retrieve Data from Multiple Sheets - Emmanuel Katto Uganda (3 replies)
  5. XML files generation (2 replies)
  6. Hello im pretty new to the office tools (2 replies)
  7. Geo location in a geo area (1 replies)
  8. Lock rows with dates 30 days in the future (2 replies)
  9. VBA split files - confirmed saved in directory, but directory is blank (2 replies)
  10. How to Apply Payments to Aged Receivables Automatically using Excel VBA (9 replies)
  11. ADS info via VBA 64bit (9 replies)
  12. finding differences (1 replies)
  13. Make a created file protected by password (2 replies)
  14. VBA - Count filtered rows in the table (50 replies)
  15. Right Hand Side Range Range Value values Range=Range.Value only sometimes. Range Range.Value Anomaly (3 replies)
  16. Help with calculating percentages (3 replies)
  17. How to insert picture using VLOOKUP Formula! (2 replies)
  18. VBA code for adding data from a sheet to another (10 replies)
  19. Dropdown menu that inserts signature Picture from selected name: Not always working or gets wrong picture (9 replies)
  20. Excel VBA Highlight Duplicates and Duplicate between Range (1 replies)
  21. Copy to Summarise data based on 2 criteria: User ID and gaps in continuous day segments for same user (18 replies)
  22. Update my existing macro to be able to update and delete (1 replies)
  23. Vlookup and Match problem (8 replies)
  24. Error in code conditional formatting (1 replies)
  25. VBA: keep only one searched string. (3 replies)
  26. in VBA if the given string is found then delete everything between two newlines where the string appears. (4 replies)
  27. Make all text file content in one line if a space found (3 replies)
  28. Copy data from multiple rows between two keyword and paste the data in row(s) of single cell in sheet2 (13 replies)
  29. CORRECT WAY TO FILL A TEXTBOX (6 replies)
  30. create form with ActiveX combobox, textbox (3 replies)
  31. Add the value taken from the user to my range for ActiveX ComboBox (1 replies)
  32. Transpose 2 column [Key, values] list to mulit column [unique Key, Value1, value2, value3, ......] list (7 replies)
  33. find last alphanumeric row of .txt file and fill into excel cell (4 replies)
  34. How can I concat a Do While result? (5 replies)
  35. Update Row on another sheet based on Cell Value (3 replies)
  36. Macro or VBA to sort values (2 replies)
  37. Explain App.Index(Rng, Rws(), Clms()) (multicolumn Combobox with Index.application) (3 replies)
  38. VBA Copy Tables from Word to Excel (1 replies)
  39. VBA Import Table From MS Word Included Format (0 replies)
  40. User Form entry in a second sheet - need help with VBA code (11 replies)
  41. problem hilighting or editing within the EXCEL CONTENTS BOX of the FORMULA BAR (1 replies)
  42. VBA : Insert Pictures With Multiple Select Picture & Consecutive Placing (6 replies)
  43. Vba - Check String/Text From Multiple Workbook Without Opening All Files (4 replies)
  44. Summarize Data from Dates to Months based on Criteria (3 replies)
  45. Autofill Text if Criteria are met (1 replies)
  46. VBA Beginer -Real Estate Industry (3 replies)
  47. Get Pictures from Word Documents in All Sub Folders (23 replies)
  48. formatting number in csv file import. Number being rounded / decimnal places truncated (7 replies)
  49. Run-time error 1004 when trying to resize a multi area range object (10 replies)
  50. How to calculate best bowling figure (cricket) (19 replies)
  51. XLM Macro 4.0 Exec string is to long/ (0 replies)
  52. VBA Macro which create new lines by codes (17 replies)
  53. Can not copy data with VBA code (2 replies)
  54. Rearrange Data - Sheet 1 into Sheet 2 Macro? (1 replies)
  55. corrupted Personal.xlsb? (5 replies)
  56. Using text in an excel cell drop down list to open Microsoft access to a specific record using VB. (2 replies)
  57. Need help to convert Excel data to XML (24 replies)
  58. Order multiple texts in "row.cells" in columns (3 replies)
  59. Display a message if already saved data (6 replies)
  60. Convert all columns with dates to serial numbers vba (1 replies)
  61. Help requested for code in an existing post (check if OCX file already registered, if not register it) (0 replies)
  62. Concatenate with style (11 replies)
  63. Dependent Drop Down Lists (12 replies)
  64. HELP - Calculation Based on Dynamic Variables (What-if Scenario) (3 replies)
  65. Run Macro one after the other (4 replies)
  66. VLOOKUP on Matching Multiple Criteria (14 replies)
  67. Align TextBox Within A Range (14 replies)
  68. Automated Search Results Returning Nothing (8 replies)
  69. Autofit Merged Cell Row Height for Some Specific Rows Only (2 replies)
  70. Macro to Count below and drag across (3 replies)
  71. Showing Custom Value Based on the Condition of Dynamic Table (19 replies)
  72. Auto Show Drop-Down List When Selecting the Cell (5 replies)
  73. Conditional Appearance of msgbox (6 replies)
  74. Can the attachment be completely turned into VBA? (No More Formula) (1 replies)
  75. Drop-Down Menu with Multiple Conditions (11 replies)
  76. Hide Comment Red Mark but Show comment on hover (3 replies)
  77. Reserve the Horizontal line numbers and information , but the calculation result is change (9 replies)
  78. Adding value of two cells to get result in 3rd cell (10 replies)
  79. VBA to show text "Enter Text Here" in excel cell (5 replies)
  80. Tree-Like Horizontal Hierarchical List in Excel (4 replies)
  81. Want to learn excel VBA (3 replies)
  82. Link same cells across multiple sheets (2 replies)
  83. Problem inserting new worksheet in Excel daily time tracker w/ date format (at specific location in book) (9 replies)
  84. Compare worksheet names (3 replies)
  85. Cut & paste between sheets Move Some Data Rows To New Worksheet Based On Conditions (1 replies)
  86. Cell Value to become part of RC in macro (2 replies)
  87. VBA intersect function for rows and column (11 replies)
  88. listbox value transfer to new excel worksheet (0 replies)
  89. Insert Pictures From Multiple Sheet in Any Cell Then Auto fit Resize (0 replies)
  90. listbox populated with Vlookup from multiple worksheet (5 replies)
  91. Extract Pictures From Multiple Sheet Overload (Occurring Duplicate) (3 replies)
  92. consolidate a notepad by vba (4 replies)
  93. Autofill and Reverse Autofill (5 replies)
  94. Msgbox notification with paasword by vba macro (8 replies)
  95. Select column based on user input (4 replies)
  96. Need a shorter VBA code: Hide and unhide sheets based on presence of name in list (4 replies)
  97. Active X TextBox with fixed width, but dynamic height (2 replies)
  98. VBA for dynamic sheets name + dynamic link + hide sheets based on a cell Value (8 replies)
  99. Copy and paste of data if matches Conditional calculation and pasting of the data (16 replies)
  100. VBA required to delimit cells with Rules applied over it. (3 replies)
  101. Add Remark in cloumn based on calculation/comparisons in one worksheet (6 replies)
  102. Identifying cells with two or more images in them (1 replies)
  103. VBA to create formula references and values in Sheet2 that either reference or are derived from Sheet1 (1 replies)
  104. Mystery with Text formatted cell - Help (1 replies)
  105. Split Multiple workbook in a folder into separate worksheet and rename the file name with Date (5 replies)
  106. VBA - Need a VBA to unprotect all worksheets in all workbooks in a given folder. (0 replies)
  107. VBA - Command Button to Multiply Value In Cell in Last Updated Column (5 replies)
  108. Populating Userform from table and change table entries (0 replies)
  109. Find & Replace during cell copy from page 1 to page 2 (3 replies)
  110. Conditional Format Based On Percentage Variance (3 replies)
  111. Close All Open Excel Files With VBA Open Close File issue unsolved (20 replies)
  112. copy and paste by VBA based on criteria (28 replies)
  113. Using "IF" in conditional formatting (2 replies)
  114. Extract Multiple Rows into a Limited Template based on Multiple Criterias (3 replies)
  115. Create copies of Worksheet (Master) based on a Range in another worksheet (4 replies)
  116. VBA: Copy files in excel, edit and save (3 replies)
  117. Apply Vlookup formula in all the available sheets in a workbook (9 replies)
  118. Populate Address From Google Search (1 replies)
  119. compare data ... Incomplete rubbish (4 replies)
  120. Mail the files by vba to a specified email id (7 replies)
  121. BB codes with Excel 365 (3 replies)
  122. Macro To Browse&Select File and import Specific Data (0 replies)
  123. Apply formula Calculation by VBA Value ="to Forumula" (24 replies)
  124. Modify the VBA code to exclude text only leave logo from signature (1 replies)
  125. VBA Simple Copy and Paste between two workbooks based on criteria (6 replies)
  126. Vlookup on multiple matches (1 replies)
  127. PARCOURIR UNE COLONNE ET COMPARER LES VALEURS EN VBA (1 replies)
  128. Excel VBA - Problem downloading first image from google (Most fail, others repeat) (0 replies)
  129. Formula To Get Best Bowling Stats From Wickets Taken and Runs Conceded [Cricket Bowling] (7 replies)
  130. Extract Data From Text File Using VBA (3 replies)
  131. Transpose rows to column and join table (1 replies)
  132. Use VBA to automate entry of schedule, scores (3 replies)
  133. Fill Column Based on Actual Time (9 replies)
  134. Remove Hard Carriage Return And Leading And Trailing Spaces (5 replies)
  135. How to populate the column 3 under this condition?? (11 replies)
  136. Open userform2 and register if the user is opening the workbook for the first time.... *SOLVED* (2 replies)
  137. Lookup First URL From Google/Bing Search Result (0 replies)
  138. Mail Merge with Variable Table Length (0 replies)
  139. Cannot read chart object (x,y) values when hovering mouse over chart using overlaid shapes (8 replies)
  140. Formula to find text pattern across multiple cells in a row. (5 replies)
  141. Use OFFSET function to define the x-axis range in a chart (0 replies)
  142. Conditional Formatting of Dates (Multiple Criteria) (19 replies)
  143. VBA Code: Copy and Paste Range if requirements met (1 replies)
  144. Top N Value using Slicer (0 replies)
  145. custom ribbon how to access checkbox (3 replies)
  146. Move values in rows at the end of the preceding row *SOLVED* (23 replies)
  147. Delete entire column if a specific string is found in a row. (1 replies)
  148. Fill Columns based on open date (3 replies)
  149. Insert Different Picture into Multiple Sheets (4 replies)
  150. VBA to Send Email Requests from Master List Array (4 replies)
  151. How to Get & Use Worksheet Name in Excel2007 Macro (3 replies)
  152. Please help me (0 replies)
  153. Misc. Leonardo1234 rider@1234 vixer. Highlighting. Simple Early stuff. Avinash Introduction (25 replies)
  154. Vba button Comparison data between two file or two tabs (59 replies)
  155. Userform Vba code to subtrack and Generate new ID (0 replies)
  156. Link spin button or scroll button to chart. (1 replies)
  157. Identifying the last duplicated string (2 replies)
  158. Automatic sort due date and send email (27 replies)
  159. Toggle Between RowSource Items And List Items In A ComboBox Based On Criteria (1 replies)
  160. Connect Excel to oracle database (0 replies)
  161. If condition: help needed (5 replies)
  162. Excel 2003. ActiveX controls embedded in worksheet not working, then can’t even insert them. *SOLVED* (7 replies)
  163. VBA Worksheet Buttons: Form controls Command Buttons verses ActiveX controls Command Buttons (0 replies)
  164. Copy data from Unique files into Masterfile all the files in the same folder. (15 replies)
  165. Make macro create unique files only once.If files exist amend them. (7 replies)
  166. VBA For each row in visible selection (1 replies)
  167. Urgent support needed. Multiple emails, multiple Excel workbooks, at once. (9 replies)
  168. VBA - Set User rights (formats, structure) (0 replies)
  169. complete page numbers (8 replies)
  170. How to turn Automatic Completion on/off in Excel 2007 (3 replies)
  171. Multiple sheet splitting (3 replies)
  172. Excel vba paste range into email body as picture (0 replies)
  173. How to automate look up of id numbers in a spreadsheet from a .csv (1 replies)
  174. create invoice with user form (7 replies)
  175. apply NumberFormat (3 replies)
  176. iam getting Vba erro1004 (3 replies)
  177. Help in SUMIF Formula (3 replies)
  178. How search two values and concatenate the result from one column !!! (9 replies)
  179. Find text and replace (1 replies)
  180. Selection range (3 replies)
  181. Time Counter (10 replies)
  182. Code to copy the active WS before a specific WS in the WB (2 replies)
  183. Sum the same cell across multiple sheets - variable number of sheets (8 replies)
  184. add zero to cells with cells with less that 8 characters (3 replies)
  185. any recommendation for best tutorial to learn scripting dictionary in VBA? (4 replies)
  186. Jump to Last Used Cell in a Column? (2 replies)
  187. How To Avoid Using Too Many OR and AND Functions In VBA (11 replies)
  188. How can you convert this VBA with use Scripting Dictionary, so it becomes fast. (9 replies)
  189. How to search google news using cell values in microsoft excel 2010/2016? (0 replies)
  190. Subtotal with Filtering (2 replies)
  191. Export data (text) Excel to Ms Word Format (0 replies)
  192. Import TXT files without VBA (4 replies)
  193. Generating numbers from a number list (3 replies)
  194. All possible on/off combos of 4 variables (2 replies)
  195. Select Column and Identify First and Last non blank cell value per segment (Range between Blanks) (8 replies)
  196. VBA Code Error (1 replies)
  197. Set Length of Worksheet Name (0 replies)
  198. How to name Excel worksheet based on min-max in column (5 replies)
  199. Append Table data to another table (4 replies)
  200. How to arrange cells like this? (8 replies)
  201. Restrict data within the Cell (Data Validation) (1 replies)
  202. VBA to upload image over another image (2 replies)
  203. Macro to Create a Combined Sheet from Multiple Sheets (2 replies)
  204. Vlookup, Index, Match formula needed for a search criteria (0 replies)
  205. Convert Text from .txt to columns in excel (2 replies)
  206. CONCAT into one cell based on 2 values (3 replies)
  207. Conditional Sum Based On Time (1 replies)
  208. SUMIF with dates (1 replies)
  209. trying to simplify this formula (1 replies)
  210. Fiscal Year Quarter Formula (3 replies)
  211. Need to modify VBA code to import data from other workbook (3 replies)
  212. send Reminder Email to Outlook if cell value reached (8 replies)
  213. Need help costumizing a graphic (3 replies)
  214. VBA Macro to open a file and extract data (0 replies)
  215. Formula Editor/Bar in UserForm TextBox? (3 replies)
  216. Need to Track the Utilization of Excel Dashboard (0 replies)
  217. Format four digit number to put decimal after first two digits (8 replies)
  218. Excel text conversion formula question (4 replies)
  219. Highlight Overlap dates (9 replies)
  220. Highlight and popup message Between employee dates are overlap using (vba) (2 replies)
  221. Copy data from one sheet to another sheet (2 replies)
  222. Re: Defining multiple variables in VBA (19 replies)
  223. Use a Loop to Copy Certain Sets of Sheets to New Workbooks (4 replies)
  224. Family Link (1 replies)
  225. hi need a code for vb to transfer excel live data to notepad daily (1 replies)
  226. Combine worksheet one after another from folder (1 replies)
  227. Code Required to calculate number of days worked, normal overtime and holiday overtime (28 replies)
  228. Macro to Identify Amounts Based on Criteria Value (3 replies)
  229. How to populate all the rows in one column based on one cell value (9 replies)
  230. Continue the calculation but stops at 99 * (18 replies)
  231. Serial number to date formula (1 replies)
  232. Display language "long date" (1 replies)
  233. Send email from Excel custom list using outlook (2 replies)
  234. Sort an array based on another array - VBA (6 replies)
  235. Excel VBA/Macro Help required URGENT (6 replies)
  236. All Data Validation Message Boxes Appear in Same Location Despite Cell Selected (5 replies)
  237. VBA Macro To Create An Excel File With Same Sheet Name As Workbook Name (14 replies)
  238. Convert Hours and Minutes From Separate Columns Into Time (1 replies)
  239. Extract Time in 24H format from Date and time. (3 replies)
  240. Alternatives SUMPRODUCT ISO (2 replies)
  241. Calculate Difference Between Start Date Time And End Date Time (7 replies)
  242. Extract Date and time from the Text Column (19 replies)
  243. Lock TextBox From Selecting Or Copying Text But Allow Scroll (8 replies)
  244. Conditional string population between sheets (1 replies)
  245. Send emails with worksheet attachment to multiple email addresses (2 replies)
  246. Dir Function not returning next file after Custom Function called (1 replies)
  247. Disable Selection Of Some Items In MultiSelect ListBox (0 replies)
  248. Merge worksheets into one worksheet (1 replies)
  249. How to send emails from excel vba (with attachment) using outlook (3 replies)
  250. Outlook Email Send Only Ranges Selected Instead of The Entire Sheet (2 replies)