Recent Activities

Ardus! You're the BEST! Bless you! Thanks

Hi,

(Code, 10 lines)

Budget Adjustment Template (VBA) v1.0.xlsm
HTH
--
AP

I don't think you were meant to start a new thread. Just amend the other thread. Let's hope that the other one gets deleted.
Re: The main emphasis of this VBA is to just add to the existing sheet as new items get added to each Of the 4 data sets.
Why not…

COPY MULTIPLE SHEETS INTO DATA


I am building a database where I Currently have several macros.
At the moment, the macros in use are perfect however I need some vba which feeds 4 separate sheets into the one data sheet.
The 4 sheets for example are: “a”,…

Hi Jiuk,

sorry where are the rules ??

Will change now, can you help???

Hi JackWhittaker, welcome to OzGrid good to have you along

Just a quick one can you change the subject title to something more meaningful that reflects your question, help the member a lot more and you getting help

Also please read the forum rules, you…

Hello All,

I work in risk management and I am currently building a database where I Currently have several macros.

At the moment, the macros in use are perfect however I need a further some vba which feeds 4 separate sheets into the one data sheet.
The 4…

Try using a select case statement instead like
(Code, 9 lines)

You're welcome & thanks for the feedback

You're welcome & thanks for the feedback

Thank you both very much for the quick replay and sorry I will read the rules.
Mark

That worked! Thank you!

Hi Roy, can you remove the attachments I uploaded on this thread?

AutoFilter Multiple Sheets, Copy, New Book, Paste to Multiple Sheets

Try using a select case statement instead like
(Code, 9 lines)

Good day
I'm having a problem that I can't figure out. I have a workbook that, when activated, emails out a report of some of the sheets. It works great, but to clean the sheets up, I want to remove the form controls as they are no longer needed. I…

I have a set of data that has a column of State abbreviations in it. Each state abbreviation has a corresponding numerical value. I am trying to use looping If/ElseIf to determine the state abbreviation in one column, and based on the value, return the…

(Code, 1 line)

Mark, welcome to Ozgrid.

Please take a few minutes to read the Forum Rules, there's a link in my signature below. I have added code tags for you, the rules will explain why.

Try this,

(Code, 26 lines)

X posted here: http://www.vbaexpress.com/foru…claring-variable-of-Sheet

I have the below code created as I want to save contractor invoices that come to me as excle and save them as PDF.
I would like to have the value 111 below be the value of cell F5 and the value D94786 be the value of cell B19.

I have googled many things…