8th

Hi, I have a spreadsheet with data pulled from an accounting system. The data reads as per the below example <tbody> Invoice Number Current +30 +60 +90 +120 Total Debtor Name Invoice Date 123456 0 10 0 0 0 Invoice Date 123457 10 0 0 0 0 Invoice Date 123458 0 0 10 0 0...

Hi, Have a 2D array R x C in size, C max (column count) = 14. Is there syntax (without explicit ref e.g. arr(x,1) & arr(x,2) & ... & arr(x,8) ) to join first 8 columns per row? Psuedo code: myKey = LEFT(join(arr), 8)where 8 represents 8th column (not 8th char!) Ideally, without creating a...

Hello friends, I need a code to select the fields (Dates) in pivot (In Pivot- Value) Example: Below code will add 7th and 8th Jan'18 field to PivotValue. But Next Week it should select 8th and 9th Jan'19 automatically instead of 7th and 8th. Please help to get this fixed...

Hi all Trying to do a bit of code where it would go thru the column and if it finds more than 7 spaces in a cell, it would copy that row and insert it under it I've tried something like this but doesn't work llr is last row Range("e3", "e" & lllr).SelectFor Each c In Selection c.Activate if...

Hi guys I want to add the sales number if the id is equal example: I want add 901 and 2994 if id is same in this case id is 40317 <colgroup><col><col span="6"></colgroup><tbody> 539 8th Ave 40317 40317 C N Y 901 539 8th Ave 40317 40317 E N Y 2994.5 </tbody>

I have a report with 7 textboxes that are populated from a query. I have created a 8th textbox where i want to sum up the textboxes. the first 7 textboxes are short text in the table. the 8th textbox i want to write a formula so it takes the current value of the 7 textboxes and show me a total...