Using Macros

[tasha23xx]

Hey,

I am going to record my first macro but I am a little confused as my example isn't the easiest.

I basically have a table on a second tab within the sheet which I will be using to pull data from however the table is an order export list so it will vary in size each time depending on how busy the sales have been.

How can I use this setup with a macro?

Any ideas or references would be amazing, thanks

 

[My Aswer Is This]

You said:

I basically have a table on a second tab within the sheet​

If by Tab you mean sheet. How do you have a second sheet within a sheet.
Or do you mean a second sheet within the Workbook.

Tell me the names of the two sheets and the Names of the Tables.

Now what do you want to do?

 

[tasha23xx]

You said:

I basically have a table on a second tab within the sheet​

If by Tab you mean sheet. How do you have a second sheet within a sheet.
Or do you mean a second sheet within the Workbook.

Tell me the names of the two sheets and the Names of the Tables.

Now what do you want to do?

Thanks for your reply, sorry if I did not make myself clear.

I have data on sheet 2 which is taken from an export. The columns will always remain the same but the amount of rows will vary depending on how many sales we have had for that period.

On sheet 1 I have columns with formulas which are pulling various bits of data from the order details on sheet 2. I would normally drag them down to match the amount of rows on sheet 2 however I am asking how I can achieve this with the use of a macro to make it easier?

The sheets are just called Sheet 1 and Sheet 2 within the same workbook?

Thanks for your time

 

[Fluff]

How about

Sub AddFormulas()
   Dim lr As Long
   
   lr = Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Row
   Sheets("Sheet1").Range("[COLOR=#0000ff]A2:H[/COLOR]" & lr).FillDown
End Sub

This assumes that your formulas are in row2 from cols A:H
Change to suit

 

[tasha23xx]

How about

Sub AddFormulas()
   Dim lr As Long
   
   lr = Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Row
   Sheets("Sheet1").Range("[COLOR=#0000ff]A2:H[/COLOR]" & lr).FillDown
End Sub

This assumes that your formulas are in row2 from cols A:H
Change to suit

This worked perfectly - thanks so much for your help!

 

[Fluff]

Glad we could help & thanks for the feedback