novice

Hi i knocked up this formula to get the sum of a columnof cells only if the values in the cells next to them were less than 20. =(IF(J15<20,K15,0)+IF(J16<20,K16,0)+IF(J17<20,K17,0)+IF(J18<20,K18,0)+IF(J19<20,K19,0)+IF(J20<20,K20,0)+IF(J21<20,K21,0)) I'm sure there's a way of condensing it but...

Hello Community, I have spreadsheets sent to me that need to be scrubbed for consistency before they are sent off. My knowledge of VBA code is rudimentary at best. These sheets can contain 2500+ lines of content, the amount is always different but the content needing to be outed is always...

I am new to VBA. I have been researching on the internet and can't find answers to my questions. I look for ward to assistance. I need to print two worksheets and two ranges (fixed - not dynamic) from two OTHER worksheets. I have gotten parts of it to work but I am not able to combine...

Hey guys, I'm completely new to this site and quite frankly it is my first time joining a forum. I'm trying to set up an excel sheet where I can record the weights of an object. In the column I want to be able to enter the weight as a number, lets say 40, and have it return as 40 lbs. Is this...

This is my first time ever to post in forum. Please forgive me if I do something wrong. Okay, here is my question. I currently have a spreadsheet that contains roughly 10K rows and 25 columns. There are two columns in this spreadsheet I want to make use of and they are item number and bin...

Hello! I am fairly new to access and I have just barely gotten around to creating tables. I want to create queries, on which I could see which patients are assigned to which doctors. I have created patient personal information and doctor personal information tables. I was wondering, if i...

Hello, Please could you help me? I am a complete novice at Excel and am trying to save myself lots of time! I need to search for 1502 staff details in Excel 2007. I need to search 9 different tabs to input consolidated info into tab number 10. Each of the 9 tabs contains the following...

Hello, I have diligently trying to write a VBA program that guides user input from column to column in a worksheet, verifying that an entry was made. It begins by inserting a new row for entry and generating a par number base sequentially on the last entry- this works! ) Then t should allow...

Hi all, I'm Dave, I'm new and I'm a complete Excel novice (think I'm probably being generous to myself there), so please be gentle... Anyway, my problem: I would like to create a dropdown list in one of my spreadsheets, which is easy enough. However, I would like for the user to be able to...

Hello I have this worksheet. Sample Data from "Demand Planning Prem" worksheet <tbody> Date SKU Name Begin FG's Add Returns Demand FG End FG's Weeks FG Excess FG 6/20/2014 ASDRK-301 Tent 5718 1 58 5661 98 5339 6/27/2014 ASDRK-301 Tent 5661 7 36 5632 156 5310 7/4/2014 ASDRK-301 Tent...

Hi, I have been trying to crack this all afternoon to no avail - I've read every thread on it and not been able to customise the macros to work! In fact - i've never written a macro before! If cells in Colomn E on Sheet '2014 Events' contain the text "Park" - Copy the Row to Sheet 'Park...

Hello Mr. Excel Helpers, I need lots of help with a nice VBA application, but I have absolutely no idea what I'm doing. I need a macro to do the following things: Save only the current tab as a pdf. Send the pdf as an email with: the name of the recipient coming from a cell in the current...

Hi Everyone, I am very limited in my Macro/VBA skills and have been trying to shorten a process my team and I do multiple times a month. Every reporting period we have to go through our reports and group/ungroup columns based on what period it is. For example, we may have the columns set up as...

I'm not an Excel poweruser and I may have bitten off more than I can chew, but here is my dilemma. I have filtered down raw data to only show providers that belong to multiple departments. There is a flag for each of these providers indicating Y/N in two different columns. I need to be able to...

I am trying to create a timekeeping/project management workbook. There is a "Dashboard" workbook used by managers and an individual workbook for each employee that feeds hours worked to the master Dashboard workbook. My problem: The Dashboard workbook contains a column for "Project Name" and...

Hi All, I am new to VBA and to this forumn, but would really appreciate your help. I am writing a code which I want to: 1) prompt the user to select a file 2) Open this file, copy multiple ranges from this file 3) Paste these multiple ranges into multiple places in the file the code resides...

My First Macro-enabled Worksheet/VBA Project: I have a table with seven header rows, 500 data rows and 1 header column. There will be roughly 40 data columns, although that may vary slightly. The four header rows contain a year and various summary statistics for the data in the corresponding...

Hi there, I apologise, as I may be asking a few questions here over the next few hours or so, as I'm not particularly skilled with Excel and have been charged with creating a register at work! Here's my problem. I need to calculate certain things from a given attendance sheet i.e. Total...

First, I rely upon this forum to help me with my job and I thank all of you Excel gurus out there for your patience with those of us who may not be as experienced and/or well versed. I have been tasked to show some data that I have mined in a graphical format, specifically a scatter chart. I am...

I am a novice currently using the following macro to filter an inventory database to find items in excel 2007. It triggers the filter to work if cell a2 is changed. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$2" Then ' Range("A3:G7951").AdvancedFilter...