ref1

I have 3 listboxes. The first one contains names, reference, and negative values. The second is structured the same way but with positive values. what I am trying to do is to loop through each row in listbox1 and check if the name exists in listbox2 and then if found distribute the negative...

Hi everyone, I have a excel sheet which called "Multi" and by using an UserForm I can activate the Word invoice path on Colum F in the excel sheet, create a PDF version of the invoice then attach to an email. This can be multiple paths triggered, multiple word version invoice converted to Pdf...

I'm looking for a function to populate column 'Hold1'. If a value in Ref2 is present in Ref1, then populate Hold1 with the corresponding value in Hold2 <tbody> Ref1 Hold1 Ref2 Hold2 15 5 35 21 23 2 58 56 16 23 15 9 2 87 25 10 60 1 89 65 13 95 34 65...

Hi All, I am trying to figure out a better way to get monthly totals for data imported from a Gantt chart into columns A to D. I added a hidden reference column that gets imported to column A in Excel. The table in the image below needs to show the monthly orders for: Australia which...

Hi everyone, I'm desperately hoping someone could help me out as I'm really struggling with this issue. I'm trying to create a spreadsheet where my friends can choose something from a drop-down box and depending on their choice, they can only enter text/numbers in a fixed format. So for...

I’m looking to do a lookup from Excel to an Oracle DB<o:p></o:p> <o:p></o:p> Normally I’d just look up the list using a quick bit of SQLand export the results to Excel to analyse however, there are over 10k rows tolookup and the limit for the SQL is 1000 <o:p></o:p> <o:p></o:p> Column 1 contains...