var

Dear all Could i seek your advice on the below Thanks in advance! I cant seem to get my Lower level calculation to sum up at the lower level, it is now calculating at every level. My sample file is available on http://drive.google.com/open?id=1lehGxqQG2vE_D3wGR0xvuZcNpMTL-Pp7 Sales...

Hi All, I just wondered if someone could advise on how the follow. I need to be able off the back of a macro for one cell to keep a count of every time a button is pressed. I google sheets i know this is possible with the following function as show below, but wondered if the same could be done...

As my title suggests I'm wanting to concatenate data that is in a single column. (e.g. Column A:A) But I only want to concatenate data in every second row (i.e. A1,A3,A5,etc...) I have another cell (e.g. B1) that contains an inputted number by the user. I'm looking for this number to limit the...

Hello everyone, I am building a cash management file and I managed to get it well untill I want to finalize my pivot-table report. The thing I am trying to obtain is exactly describe here : https://www.youtube.com/watch?v=q5M20UwxY1Q but for a confusing reason I don't obtain the same result...

Each day I enter my weight in a cell running across the sheet Sunday - Monday 7 cells D3 - J3. I want to have the 8th cell K3 tell me each day how much I have loss since Sunday D3?

I have quantities in cell D3 thru J3. D3 cell has the count of items at the beginning of the week. Each day the new inventory count is in the next cell. I want to be able to total at the end of each day how many items were sold?

Hello, I have a big Excel file with many worksheets&hyperlinks to other documents all over my PC. After I update to Win10 the path for documents (and hyperlinks) is changed: Old = C:\Users\nzw\AppData\Roaming\Microsoft\Excel\... New = C:\Users\nzw\AAA\... The "..." contains the rest of path...

Hi All, i have problem with my excel table. I have table(sheet BA11) with almost 4k row and in this table are subtable repeated every 30-36 row. Every subtable has same layout but not same number of row. I need extract from table 2 value and this is Name and Total. Name alwas start NAME: xxx...

Hi All, i have problem with my excel table. I have table(sheet BA11) with almost 4k row and in this table are subtable repeated every 30-36 row. Every subtable has same layout but not same number of row. I need extract from table 2 value and this is Name and Total. Name alwas start NAME: xxx...

I have a 'master' sheet that contains a big Table with several columns (A:G) and 283 rows (with header). The other Sheets contain sections of this 'master' table based on unique values in Column B (i.e. Column B is filled with names like 'dog' 'cat' 'pig' 'horse' etc. and these could appear...

Hi, i would like to start using the Summarize and ADD Column formulas. i managed to create to use the formula that will create new virtual columns for me but i dont understand how to use them for example: i have created the below formula that create a virtual table with 8 columns ( Sales...

HI, I HAVE DATA INPUTS IN CELLS A1 TO A5. I WANT VALUES IN "INPUT CELL "TO CHANGE BASED ON UNIT SYSTEM (METRIC SYSTEM OR BRITISH SYSTEM) IF SELECTED AT FIRST. it is important to consider that that values in CELL A1 TO A5 ARE "INPUTS" FOR EXAMPLE...

Hi Friends, I am trying to copy multiple discontinuous columns. rU = Null For var = 0 To c.Count - 1 rU = Union(rU, wsI.Columns(Int(c.Items()(var)))) Next var rU.Copy Here I have my column numbers in a dictionary.I am running a for loop to populate all columns in rU...

I was creating excel file for my online orders. Sometimes buyers buy multiple items in same order. So we receive report as repeated order ids (in rows) with different product names. So when i use pivot it gives multiple products in the same column. So we can't use lookup option when we have...

Whether I convert a number to "text" format, or use the apostrophe to indicate a text string that consists of numbers, I can still perform calculations on those strings. Why is that? Even crazier, I changed the number converted to "text" format to a string of letters, and my IF function still...

Hello I’m new to this and hope you may be able to help. I regularly get two columns of figures which I want to import into columns B and C in a worksheet. The goal is to end up with both columns the same. I therefore need to identify the differences between the columns. The problem is that...

Hi there :nya: Need some help. Currently this macro only finds cells containing the exact text entered into the text box Search_OrganName. I would like it to find any cell from the range that contains that text rather than just exact matches. I'm thinking there is a really obvious solution...

Would someone please explain why I get the error. in Excel 2013 Run-time error '1004': Application-defined or object defined error Senario (Description followed by code) I have opened a workbook and worksheet (wsBS) from within the main worksheet (wsData). I want to find the last row of the...

Hello, I'm trying to fill MODEL 1 from MODEL 2.Model 2 is my main worksheet, it is organized like that because is easier to understand what is whapeping with that especificy TAL, but horrible to analyze them.So, i looking for a way to organize model 2 to in order to fill model 1, but i still...

I have a TAB called KITTING. This TAB has the totals from 7 other tabs. The TABS are labeled STN, MDF, BACKBONE, CCTV, FIRE, ACCESS-IDS, PATH. Each of these TABs have the top row with PART NUMBER (B3), DESCRIPTION (C3), MANUFACTURER (D3), QUANTITY (E3), UNITS (F3). I would like to also add a...