I'm looking for a macro that presents a list consisting of data from another worksheet in the same workbook.
I would then like to be able to count and post the result of the counter in yet another cell of the sheet, every time the selection is chosen.
Thanks so much for your help or...
This one seems simple but gets hairy as it goes on:
I have 2 columns of 182 rows of data (A + B)
I need to copy 2 rows of existing data (b10 & b11) ahead of each B cell containing current data.
I need to insert 2 blank rows below each A cell with current data.
This is what I have (Ignore...
I am having issues when I attempt to add a formula to a worksheet cell via VBA, firstly even if I use a variable.string it still falls over, the code I have an issue with is as follows
when I check the cell I get =COUNTA('D3':'D300')" instead of getting =COUNTA(D3:D300)"