Search results

https://www.microsoft.com/en-us/download/details.aspx?id=7609 try here to download power pivot

Hi Dheeraj, pls check here powerpivot for 2013

You are welcome.

Pls check this out

Is it like you wanted to have?

You can modify the codes as per your requirement. Select all like shown in below screenshot, you get all customer & address details in given pivot.

Try here pls: https://excelchamps.com/blog/vba-to-create-pivot-table/

I think you can achieve through Pivot table

Hello, you wanted to paste data as follows: Sheet1 ‘column D’ = column B in all sheets Sheet2 ‘column C’ = column F in all sheets

Please try this last row; LR = Columns("A").Find("*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows, LookIn:=xlValues).Row

We can get the total days you will charge. But i'm not sure to spilt them to last month.

Which col you refering in the exel?

In given example, col T shows the end of free time. then from that date you will charge .50 , till when you charge?

free time is based on date of received & not based on date of load? Am I right?

Here you go .. Sub Transfer_data() Dim lastRow As Long, WsEntry As Worksheet, WsDb As Worksheet Dim Cus_Found As Range Set WsEntry = Sheets("entryform") Set WsDb = Sheets("database") Set Cus_Found = WsDb.Range("B:B").Find(WsEntry.Range("customerID").Value) ' to check customer id already...

Hi, I hope you wanted to keep updating the data to database for every entry in entryform.

Thank you @Chihiro

So, Is it possible to download from Sharepoint online?

@Chihiro I tried to use above code but failed to execute it. Getting error that, file not available in sharepoint folder. Could you please share the excel with this or working code to download file from sharepoint.

To download file from Sharepoint, Please have a look here in the thread: https://chandoo.org/forum/threads/vba-code-to-download-files-from-sharepoint-to-local-network-drive.25320/ Code:http://ckannan.blogspot.com/2012/09/vba-download-files-from-sharepoint.html

You need to have a practice of using Option Explicit at beginning of the code. Kindly check out here for further inputs:http://www.homeandlearn.org/option_explicit.html

R4 not declared as range

Okay...

only data differ or even the name changes too, ex: wk35 -6 names & wk56- 8names??

in Col A of Week sheet, is the same number of Name's details will updated in Week_archive sheet?