Posts by rkaus

Re: Summary Table In Vba

Refreshing all pivot tables will be of help to me. Will try and let you know

Thanks for the response.

Re: Summary Table In Vba

Attaching my sample data again

The requirement is - I need to prepare different summary tables. I have given 2 in the sample file attached herewith. But, in reality the no. of summary tables is as many as 20 and the base data will have as many as 30 to 40 columns

Each summary table will be based on a different column i.e. in the sample data, it could be based on product, it could be based on region etc

Re: Summary Table In Vba

The actual data has multiple columns and the data has to be organised based on different combinations. If I use pivot tables, I have to refresh all the tables one by one. I may run the risk of not refreshing some tables. Also, adding more pivot tables is increasing the file size.

I am currently using sumif in excel itself. But since there are lot of tables which are to be updated and the database is also big, it is again taking a lot of time to refresh

I am looking for a way of updating the calculations in a faster way. If I can run a macro, I thought the data updation will not take time as the cells will not be updated for every single data i key in. By having a macro, i can also avoid increasing the file size.

Please suggest if i am wrong

Hi

I am trying to populate values in a summary table using Vba. Details as per attachment. Please help

Re: Calculated Date Based On Date In Another Column

Hi

Thanks both of you. It works

Col A has dates which can be any date of a month. I want to calculate dates in col B which will be the first of the month of date in col A
Eg:
If A1=10 Jan 07 , B1 should be 01 Jan 07
if A2 = 28 Apr 07, B2 should be 01 Apr 07
if A3 = 01 Feb 07, B2 should be 01 Feb 07

Is there any excel formula for calculating this please

Re: Compare Data In 2 Workbooks And List Missing Data

Hi

This is working.. Perfectly

Thanks so much

Re: Compare Data In 2 Workbooks And List Missing Data

Hi jindon

Did not notice ur reply as I was working on the previous reply.

Will check your code and reply.

Thanks

Re: Compare Data In 2 Workbooks And List Missing Data

Hi
Thanks for the reply. But I am having trouble. Could you please tell me which is old range and which is the new range.

i am getting an error "Subscript out of range in the code Set r = Book1_Range.Find...

Please help

Re: Compare Data In 2 Workbooks And List Missing Data

hi

i am putting the question simply...

there are 2 columns with data. ColA is a new list, ColB is the old list. I want to compare colA with colB and list all those in ColA that are not there in ColB.

Intention is to identify the new entries

I have data in 2 workbooks. Book1 - Sheet1 - Col A and Book2 - Sheet2 - Col A.
I want to compare Book2 with Book1 and list all values in Book2 that do not find a match in Book1

I want to run a macro for this please

Re: Delete Records

yeah.. that works... thanks

I want to run a macro to delete all records in a worksheet. Can someone give me the code please...

Re: List All Files In A Folder

Thanks so very much:)

Re: List All Files In A Folder

Thanks a lot. That is of help

But is it possible to list the the filename alone without the full path or the file extension?

I want to run a macro to list the names of all files in a folder in a worksheet. I want the file names along with extensions. Please help

Re: Get File From Cell Values And Save In Another Folder

bump

Re: Get File From Cell Values And Save In Another Folder

bump

Re: Get File From Cell Values And Save In Another Folder

bump

Re: Fetch A File Based on Hyperlink value And Save In Another Folder

bump