Robuta

Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.

XL Comparator is a free tool to compare two Excel or CSV spreadsheets without programming Excel macros nor installing software on your computer.

Best answer: Apologies, having tried again I have figured out where I was going wrong! I hope I have not wasted anyones time! If anyone is interestet at all,...

Hello, I'm trying to create a formula if I input an age range ex. 17-24 in one column then write a price, if another age range is entered ex. 25-29 then write...

Best answer: Hi before pasting to a new sheet, just put the row and column number to variables and after pasting retrieve them...

Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.

Best answer: Suppose your data is in Range A3 to onward so using this formula in =OFFSET(Sheet1!$A$3,0,0,COUNT(Sheet2!$A:$A),1) or you can use countA function...

Best answer: and the question is ?...

Best answer: Option Explicit Sub GLLoadDataGenerator() 'Write GL Test Data to a tab delimited .TXT file Dim NumberofRecords As Variant, i As Variant Dim myPath...

Hi, I need a help to match values in a column from other two columns. I have two columns with some values on them. I have another column [third] with some more...

WINDOWS 7 EXCEL 2007 Hello, I would like to make a macro that would convert the data below to (See-Below) LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS...

Apr 30, 2024 - In the latest installment of "Uncompromised," a member of Red Canary's incident handling team analyzes a malicious Excel macro from a red team...

Hello, I am trying to create a macro in Excel 2003 that will compare data in Column A to Column B. The cells that are in column A and B will vary each time. I...

Learn to run the same macro on multiple worksheets at once in Excel using VBA. A step-by-step guide with code to execute macros on all sheets simultaneously.

In Word 2003 I had a macro and put it on toobar to select table row, copy it, paste it so I got a new row below current one, in a flash. Highly repetetive...

Hello, I am trying to write a macro in excel but it has me completely stumped. I want to paste into column P the word 'resolved' for each cell where the...

Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.

Best answer: sample trivial data sheet1 enter A1 1 a2 2 highlight A1:a2 and drag down upto about 108 rows (more ok) it will 1,2,3,4,5, etc copy sheet1 data in...

Excel & Data Processing Projects for $3-5 USD / hour. Hi Excel Expert, I am looking to hire a excel expert. Task: numbermic value checked with if condtions and...

In this blog, you will learn about Simple Macro in Excel and Automate the Repetitive Process.

Best answer: Hi The problem seems to be in the line Cells(lngLastColumn + 1, lngRow).Formula = "=Sum(" & Cells(1, lngRow).Address & ":" & _...

Best answer: I spent a lot of time trying to figure this out and finally got the correct Macro. All you have to do is highlight the information in the column...

Setting macros in Excel VBA is fairly simple. The structure for Excel VBA macros involves starting with a sub() line before beginning the macro code.

Hello, I need a macro to do the following: Look for the word prod in column C (500 rows). When it finds it, replace it with 814, 815,816 - three rows replace 1...

Hello, I am really struggling to get a macro to run automatically. I have created a sheet that logs entry/exit from my offices. I have created a macro that...

I have data in two columns that I am trying to combine, but keep in separate columns. So I have: A 1 B 2 C 3 And I need this: A 1 A 2 A 3 B 1 B 2 B 3 C 1 C 2 C...

Hello, i have a macro to fill in blanks. Is it possible to run it for multiple columns at the the same time. Thanks Configuration: Windows XP / Firefox...

Hello, I want my macro to 1) create a new sheet and 2) copy data from another sheet onto the new sheet. For some reason it (my macro) will create the sheet but...